Formating/Macro/Script Help

  • Thread starter Thread starter Shepord
  • Start date Start date
S

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
 
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.
 
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.
 
Is there a way to automate a selection of only cells with GO? This will
allow text to column.

Thanks
 
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.
 
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
 
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.
 
Back
Top