Split cell contents

Hi everyone,

I have several cells with a various amount of 8-digit numbers in them (see below for example). Some cells have anywhere between zero to twenty 8-digit numbers in them. How can I split up these cells, so that it pulls each 8-digit number and puts it into its own cell?

10000000 10000008 21546587 68555898 10035288

I know I can use text-to-columns with a fixed width, but this would take forever. VBA code perhaps?

Thanks!!

Hey xlbiznes!

That doesn't work for my project, the thing is each cell looks like this:

xxxx xxxx xxxx xxxx

So the problem is that the delimiter as a space won't work, since there are no spaces.

Any thoughts? Thanks for the code though, this is exactly how I want to approach the project.