If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You send a clear explanation of what you want
3. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Don Guillett" wrote in message
...
How about fixed width and then delimited on /

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Shepord" wrote in message
...
I am trying to do a text to column specific data in column A. What would
be
the best way to do this? Below is a example of what I have and what I
would
like.

Before
A B C D
1 GO/To/Home: 10/15/18
2 123/42
3 148/46
4 178/19
5 GO/To/Home: 15/20/18
6 123/42
7 178/19
8 GO/To/Home: 10/15/19
9 148/16/25


Would Like
A B C D
1 GO/To/Home: 10 15 18
2 123/42
3 148/46
4 178/19
5 GO/To/Home: 15 20 18
6 123/42
7 178/19
8 GO/To/Home: 10 15
19
9 148/16/25