| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Uncombining" Text
Question:
In cell A1 I have a name "John Smith". How can I move "Smith" to cell A2 so that I can sort by first or last name. Thanks. Bruce |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"Uncombining" Text
Try using 'text to columns' located in the Data menu. Follow the wizard and
make sure you select space as the deliminter. "Bruce" wrote: Question: In cell A1 I have a name "John Smith". How can I move "Smith" to cell A2 so that I can sort by first or last name. Thanks. Bruce |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"Uncombining" Text
Thanks. It worked.
"sjk153" wrote: Try using 'text to columns' located in the Data menu. Follow the wizard and make sure you select space as the deliminter. "Bruce" wrote: Question: In cell A1 I have a name "John Smith". How can I move "Smith" to cell A2 so that I can sort by first or last name. Thanks. Bruce |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Aligning Wraped Text to the bottom of a cell | Excel Discussion (Misc queries) | |||
| Conversion to Text file format error | Excel Discussion (Misc queries) | |||
| Shade cell according to text? | Excel Discussion (Misc queries) | |||
| Using Concatenate function to generate text in Text Box | Charts and Charting in Excel | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Linear Mode
