Separate data in a cell

[Davidprince]

Ladies and Gents
A Merry Xmas. I have copied data from a pdf and have this type of data in an excel2007 cell:

K098768 J7685

I want to leave the cell as K098068 or have the same result in an adjacent cell. I seem to recall a similar problem on your website some years ago, but it involved separating CSV data.

There are some 400 of these and a macro or some VBA code would be handy. Any suggestions would be much appreciated as I need to have the data submitted by 27 or 28th and don't have a lot of time to test solutions.
Thanks
David

 

[SkipVought]

Hi,

I'd use the Data > Text to Columns feature--Delimited by SPACE.

Turn on your Macro Recorder to record this code if so desired. Post back with your recorded code if you need help customizing.

Merry Christmas!

 

[Davidprince]

Thanks Skip, great solution as always...you are a star. Just shows how much Excel I have forgotten.

 

[Andrzejek]

Skip, [...] you are a star", well, yes, he is. Not just call him a star, give him one. Click on
[blue]
Like this post?
Star it![/blue]
on his post to show appreciation for his help.



Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.