View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
wjohnson
 
Posts: n/a
Default How to Breakup text in to two parts ina cell


If the text in your column has a common point where you want to split,
or it has some type of delimination you can select a single column, go
to the menu bar - select "Data" - then select "Text to Columns" and
follow the information on the pop-up menu.
If you do this and you want to split a column into 2 or more columns -
make sure the same number of columns to the right are "blank" or you
will overwrite what is already there. The program will give you a
warning and ask "do you want to do this.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.hightechtalks.com/m390
View this thread: http://www.hightechtalks.com/t2296610