Extracting numbers and letters in a single cell to separate cells

[lawandgrace]

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

 

[Jacob Skaria]

In M3
=--LEFT(L3,LEN(L3)-1)

In N3
=RIGHT(L3,1)

and copy down the formulas

If this post helps click Yes