Thread: How to split up text
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default How to split up text
Select your column then

Data|Text To Columns
Select 'Delimited'
Next
Put a / in the other box
Finish


Mike


"Hilton" wrote:

How to change
LSD/1/1
REMAD/1/2
NSFE/1/1
CLKSAD/2/1

into
LSD 1 1
REMAD 1 2
NSFE 1 1
CLKSAD 2 1

Thanks

Reply With QuoteReply With Quote