View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
mpstockdale mpstockdale is offline
external usenet poster
 
Posts: 1
Default Separating Two Data Sets from one Excel Cell into Two Cells


-Is the text always "pt"?-


When there is text, it is pt, and it has to remain with the first set
of numbers, but the pt value is not seen much.


-
If yes, then I'd select the column.
edit|replace
what: pt
with: (space bar)
replace all
-


How will that affect the "pt"?

-
Then use data|Text to columns to parse the contents into two cells.
-



I apologize, but I don't know how to do this. Can you explain
further?

Thanks!


--
mpstockdale
------------------------------------------------------------------------
mpstockdale's Profile: http://www.officehelp.in/member.php?userid=4378
View this thread: http://www.officehelp.in/showthread.php?t=1222238

Posted from - http://www.officehelp.in