Extracting numbers and letters in a single cell to separate cells
In M3
=--LEFT(L3,LEN(L3)-1)
In N3
=RIGHT(L3,1)
and copy down the formulas
If this post helps click Yes
---------------
Jacob Skaria
"lawandgrace" wrote:
I have the following data (examples) below in single cell:
Cell L3:
17E
17A
4A
4B
And need to extract the data, separating numbers/letters into two different
cells:
Needs to go into Cells M3 and Cell N3, respectively:
17 E
17 A
4 A
4 B
This is just a sample. The letter range is A thru F. The number range is 1
thru 26.
Thanks for your help!
Mike
|