reporter1
Thread Starter
- Joined
- Mar 6, 2008
- Messages
- 43
Hi Excel Pros,
I'm no excel wizard and I'm having difficulty separating strings of text and numbers from one cell into separate columns.
Here's an example:
MONSEF,BERNADETTE03/25/910930DMRAAM10-t/f1000150012001730
I'd like the information separated as follows:
MONSEF,BERNADETTE 03/25/91 0930 DMRA AM10-t/f 1000 1500 1200 1730
Each row has different length names, dates, times etc...
Is this even possible to accomplish with a formula?
Dizzy,
reporter1
I'm no excel wizard and I'm having difficulty separating strings of text and numbers from one cell into separate columns.
Here's an example:
MONSEF,BERNADETTE03/25/910930DMRAAM10-t/f1000150012001730
I'd like the information separated as follows:
MONSEF,BERNADETTE 03/25/91 0930 DMRA AM10-t/f 1000 1500 1200 1730
Each row has different length names, dates, times etc...
Is this even possible to accomplish with a formula?
Dizzy,
reporter1