Thread: I want to seperate two words in same cell to be in two diffrent ce
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
  
Posts: 10,124
Default I want to seperate two words in same cell to be in two diffrent ce
datatext to columnsdelimitedspace

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"oasalako1" wrote in message
...
Hi,
Kindly help.. I need to seperate two letters in same cell into two
different
cells

e.g Cell A1: 5000030 Salary

I need it to be
Cell A1: 5000030
Cell A2: Salary

Please, how do I do this, can anyone help?

Thank you
OluD

Reply With QuoteReply With Quote