Formating/Macro/Script Help

[Shepord]

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

 

[Luke M]

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.

 

[Don Guillett]

How about fixed width and then delimited on /

 

[Shepord]

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.

 

[Shepord]

Is there a way to automate a selection of only cells with GO? This will
allow text to column.

Thanks

 

[Luke M]

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.

 

[Shepord]

The problem with this is there is data in B, C and D except rows 1,5 and 8.
If I do this it will delete that data. I am wondering if there is a function
or way to multi select cells only with GO?

Thanks

 

[Don Guillett]

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.