| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how do i unstring text in an excel cell?
a cell contains "123 a b". i want to unstring it into three cells in the
same row. |
|
#2
|
|||
|
|||
|
There is an Excel feature called Text to columns that does exactly what you
want. 1. select the data 2. pull-down Data Text to Columns... and let the wizard guide you. -- Gary''s Student "phillieberman" wrote: a cell contains "123 a b". i want to unstring it into three cells in the same row. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Does Excel 2003 have a shortcut command to wrap text in a cell? | Excel Discussion (Misc queries) | |||
| Can I create an IF formula for single cell w/ dif. text in Excel? | Excel Discussion (Misc queries) | |||
| format a text cell in Excel | Setting up and Configuration of Excel | |||
| in excel can one repeat the text from a the last used column cell. | Excel Discussion (Misc queries) | |||
| How I do I rotate text in an excel cell? The rotate commands is g. | Excel Discussion (Misc queries) | |||
Linear Mode
