Thread: Urgent Help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kiran kiran is offline
external usenet poster
 
Posts: 65
Default Urgent Help

Hi All,
I have data in column A as follows

iut data
wexpro, data
cas - factory
pondy-sales
coffee:beverages fact

I want my output in B column as follows
A B
iut data iut
wexpro, data wexpro
cas - factory cas
pondy-sales pondy
coffee:beverages fact coffee

TIA