Thread: length of word
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
egun egun is offline
external usenet poster
 
Posts: 88
Default length of word

I thought about this, but assumed that the second part of his text could have
multiple words - it's obviously a brand or company name, so text to columns
would put the rest of the cell text into multiple columns.

"FSt1" wrote:

hi
assuming that your example data is characteritic of all your other data then
the easiest way would be text to columns
on the menu bardatatext to columns
select delimitedspace
make sure that you add a blank column next to your data. text to columns
will overwrite the data in the next column.

Regards
FSt1

"dstiefe" wrote:

I have a column of data that read like

Glass Bacchus
Glass Alverdi


I want to first copy the "glass" text and put that info in another column

and then I want to delete the "glass" text so there are no spaces before the
Bacchus or Alverdi word

thank you