View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
arcticale
 
Posts: n/a
Default a look up question

I asked yesterday but now I dont see my posting.

My question is : I am trying to create a new column where this new column
will contain a one word text extracted from the first column. Example, I want
to have my second column to show the word warehouse for all those rows in my
first column that have the word Warehouse. The word warehouse in the first
column are in different position. Then, all rows that have the word
fullfillment in the first column will have the one word fullfillment in the
new column. Again, the word fullfillment is in different position. I have
various of this type in a huge spreadsheet.

Will greatly appreciate all your help.

thanks,
del