Thread: Split a cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default Split a cell

Hi,
Highlight the column you want to split, then go to Data, Text to Column,
Delimited, in delimiters check only other and in the box enter \ then click
next and Finish
You are ok now
If this was helpful please click yes. thanks

"israel" wrote:

Hello,

I placed a inquiry for help on spliting a cell, I did get notification that
it was answered yet I can't find the answer.

Question was if I have a cell with quantity and size in one cell separated
by "/"
can I split it into 2 cells. For instance 3/5.4 stands for 3 in quantity
and 5.4 for size

I tried to click on my notification but it does not takke me to my answer

Thank you again
--
smile