Posted: 1/23/2014 9:32:09 AM
Originally Posted by Bart_
try using the left or right trim.
Here's how I did it (got help from another forum)
Say, you have your Data in Column A beginning from Row 2.
Say in A2 you have W -160
and in A3 you have L 136
In B2 write this.
You will extract the Alphabet W in B2.
Copy B2 and paste it in B3.
You will extract the Alphabet L in B3.
In C2 write this.
You will extract -160 in C2.
Copy C2 and paste it in C3.
You will extract 136 in C3.
If you have the formula directly in the sheet, in case if you change the data in column A, then your results in Column B & C will change.
As an Alternative, you can copy the results in Col B & C and using Paste Special you can paste only the result excluding the formula in Col D & E.