View Single Post
  #1   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


I have data in an excel cell such as below:
*XXXX.XX.XX XXXX.XX.XX*
Sometimes it will appear as:
*XXXX.XX.XX yy XXXX.XX.XX*
The "yy" value is part of the first set of Xs.

It is actually two separate data sets. Is there a way to write a
formula that will let me separate the data into two separate cells?

Thank you in advance for any assistance!

Marty


--
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