| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| transfer data into row cells from column cells in Excel | Excel Discussion (Misc queries) | |||
| Macro question | Excel Worksheet Functions | |||
| resetting last cell | Excel Discussion (Misc queries) | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
Threaded Mode
