Copy cell with space into 3 columns?

[niguagua]

I have data in about 1000 rows with a letter, a space, a set of numbers, a space and then another set of numbers. Is there a way I can copy the data from the single cells into 3 separate columns?
I looked through lots of forumes and I still don't even know where/how to start. Please help! Thanks.

[VBA Noob]

Hi,

Try

Data > Text to Columns > Delimter will be space

VBA Noob

[Paul]

You can use 'Text to Columns' and set the Space character as delimiter.

Select your column of data, then choose Data --> Text to Columns... from the menu bar.

On the first screen, select 'Delimited', click Next

On the next screen, check the box next to Space (and uncheck any other delimiters). Then make sure 'Treat consecutive delimiters as one' is checked. Click Next.

On the third screen, set the Destination location to another cell or column. (If your data is in column A, type =$B:$B in the Destination to start your delimited data in column B. Click Finish.

[niguagua]

Great! Thanks so much! Sure is going to save me lots of time!