Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
reordering text and numbers in a cell
I have a column of data (G) which has people's names and roll numbers in it.
These are user input and although the correct format is 123456 John Smith there are instances where the name is before the number or there is no number or name e.g. 123456 John Smith Bill Bobbins 987654 Fred Figgis 438764 Mike Morris 907856 I need to reformat the data so if there's a number it always appears before the text so the above examples would show as: 123456 John Smith 987654 Bill Bobbins Fred Figgis 438764 Mike Morris 907856 I haven't been able to do this formulaically yet so I'm really struggling to find a manual solution. Any help would be greatly appreciated. Thanks a lot |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to extract numbers from imported cell with text and numbers? | Excel Discussion (Misc queries) | |||
copy numbers from numbers+text cell | Excel Worksheet Functions | |||
Extract numbers from cell with Text and Numbers | New Users to Excel | |||
How do I extract numbers from a cell with both text and numbers? | Excel Worksheet Functions | |||
extract numbers from cell containing text & numbers | Excel Worksheet Functions |