View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
lawandgrace lawandgrace is offline
external usenet poster
 
Posts: 27
Default Extracting numbers and letters in a single cell to separate cells

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