|re: I have a row of cells with letters and numbers|
In your example, it looks like you have a column of cells with letters and numbers, so that is what I will try to help you with.
Without using VBA, it would be very difficult to get the result you are looking for while leaving the letters and numbers in one cell.
Here is what I would do:
Let's assume your data is in A1:A5.
1 - Select A1:A5
2 - Use Data...Text to Columns...Delimited...Next
3 - Check the boxes for Space and Other, and put a / in the Other field
That should give you this:
A B C
1 E 400 400
2 E 400 150
3 W 400 150
4 W 400 400
5 W 400 400
Then you could use this to get your answer: