Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count only Letters in cells that contain both letters and numbers | Excel Worksheet Functions | |||
Extracting Address data from single cells | Excel Worksheet Functions | |||
summing 2 to 8 separate numbers in a single cell | Excel Worksheet Functions | |||
extracting comma seperated from a single cell and auto populating in selected cells o | Excel Discussion (Misc queries) | |||
How do i separate full names appearing in single cells? | Excel Worksheet Functions |