Converting text from Word into Excel

[saraereinosa]

I have text that I need to put from Microsoft Word into Excel, but each space would distinguish when it should be a new cell within excel.

For example:

In word....
62C 64C 2 87.482 89.918 8779069 99 99.0000 *NP 000000000000000 62C 64C

I need the following:
[TABLE="width: 500"]
<tbody>[TR]
[TD]62C
[/TD]
[TD]64C
[/TD]
[TD]2
[/TD]
[TD]87.482
[/TD]
[TD]89.918
[/TD]
[TD]8779069
[/TD]
[TD]99
[/TD]
[TD]99.0000
[/TD]
[TD]*NP
[/TD]
[TD]000000000000000
[/TD]
[TD]62C
[/TD]
[TD]64C
[/TD]
[/TR]
</tbody>[/TABLE]

Is there an easy way or a macro that can do this?

Thank you!

 

[patel45]

select your test, copy, select a cell in Excel, paste, clic on Data, Text in columns, delimiter = space