| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text to Columns help
Hi
I have a column with name like below McAllister Mr & Mrs E. Hay Mrs E. Farquhar Rev. G. & Mr M. Russell Mrs M. Cuthbert Mr & Mrs J. Cuthbert Mr R. Cuthbert Miss Judith Weller Mr & Mrs M. Doherty Mrs C. Stewart Mr & Mrs J. Ridges Mr W. Is it possibe to do Text to 2 Columns on them all in one go? I'm having to do long names like McAllister Mr & Mrs E. into 2 colums McAllister & Mr & Mrs E. & short names Hay Mrs E. into Hay & Mrs E. seperately which is going to take ages as there are 14 similar pages Can anyone offer a solution please -- Martin ©¿©¬ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining Text from 2 Columns into 1 then Deleting the 2 Columns | Excel Worksheet Functions | |||
| help with sorting text in columns to match other columns | Excel Discussion (Misc queries) | |||
| merge text from 2 columns into 1 then delete the old 2 columns | Excel Worksheet Functions | |||
| Excel is automatically doing "text to columns" upon paste text. | Excel Discussion (Misc queries) | |||
| Linking text columns with text and data columns | Excel Worksheet Functions | |||
Threaded Mode
