[eolverag]

Hi everyone, i have a situation here and hope you could help me solve it.

I have a spreedshet with consumer information and i want to analyze the data, the spreedsheet i receive has a column named product description and has different information in it that i want it to be splited into different columns. i already try to use the Text to Column wizard but it doesnt help me at all. heres an example of this column.

Product Description80651906-HS COND RELAX 200MLX12IT80629451-He&S Sh Mentol Refrescante 400mlx12it80651967-HS FALL PREVENTION 700MLX10IT80629515-He&S Sh Limpieza Renovadora 700mlx10it80629521-He&S Sh Esencias Marinas 700mlx10it80649355-HEADSH COND HUMECTA 200MLX12IT BRASIL80639137-PANTENE AC HIDRATACION 200MLX12IT

The result im looking for should be like this:

ID Brand Technology Version Size Additional
80651906 HS COND Relax 200MLX12IT
80629451 He&S Sh Mentol Refrescante 400mlx12it
80651967 HS N/A FALL PREVENTION 700MLX10IT
80629515 He&S Sh Limpieza Renovadora 700mlx10it
80649355 HEADSH COND HUMECTA 200MLX12IT BRASIL80639137 PANTENE AC HIDRATACION 200MLX12IT

Could anyone help me to code this on a macro ???
THX A LOT !!!!

[Keebellah]

Have you tried the Text to columns?
Its a standaard menu option in Excel. In Excel 2007 and 2010 you can find it in the ribbon under the Data menu option
You can even record a macro for future use

[scotty718]

He can't do TTC.The data has to many spaces that may or may not define the columns he needs.

I've done some manual work with one small vba code, since there would be no code that could just nail it - or at least no code that can be developed very quickly!

I parsed out ID, Size & Additional. But I didn't know how to separate Brand, Technology & Version. I left that in a column called Data to Finish. That should be pretty easy for you to extract given the small data set.

[Keebellah]

Okay. I'll check it, first I have to see the match Nadal-Djokovic!!! (I'm for Nadal)

[Rollin_Again]

This shouldn't be a problem but I would need to see the original data in the actual workbook. Can you post the before and after data in your attached workbook?

Rollin