Formating/Macro/Script Help
 

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

Formating/Macro/Script Help
 

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

Formating/Macro/Script Help
 

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

Formating/Macro/Script Help
 

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

Formating/Macro/Script Help
 

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

Thanks

"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

Formating/Macro/Script Help
 

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

Formating/Macro/Script Help
 

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

"Luke M" wrote:

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

Formating/Macro/Script Help
 

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