The first conversion using space as a delimiter will only affect rows 1, 5
and 9. After that, your dealing with column B, so you're okay to just use the
slash as a delimiter.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Shepord" wrote:

The problem is in the example I want to only do this to rows 1,5 and 9. The
data I am using this on is too large to manualy select the cells to perform
this action.

"Luke M" wrote:

You could do a 2-step Text-to-column with delimiters. First, use a delimiter
of a space to seperate the Go/to/Home: from the rest of numbers, then apply
2nd text-to-columns on the numbers now in column B with a delimiter of a
slash.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Shepord" wrote:

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