Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
the easiest way is to highlight all the colums and then go
to the data menu and go to 'text to columns' and then hit next and put the line where you want to seperate them. -----Original Message----- Can I split text in a column like the example below into three columns? Column = Column1 Column2 Column3 1 1234 John W. Doe = 1 1234 John W. Doe Thanks, milo . |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Split text into multiple columns using a common delimiter | Excel Discussion (Misc queries) | |||
split one column to multiple columns | Excel Worksheet Functions | |||
split one column into multiple columns | Excel Discussion (Misc queries) | |||
Split numbers and text from 1 column into 2 columns | Excel Discussion (Misc queries) | |||
text from one column into multiple columns | Excel Discussion (Misc queries) |