Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Business Applications Business Applications
Search Search
Search for:
Tech Support Guy > > >

Excel Split text macro


(!)

eolverag's Avatar
eolverag eolverag is offline
Junior Member with 1 posts.
THREAD STARTER
 
Join Date: Sep 2011
12-Sep-2011, 12:46 PM #1
Excel Split text macro
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 !!!!
Attached Files
File Type: xlsx Data example.xlsx (9.8 KB, 100 views)
Keebellah's Avatar
Keebellah   (Hans) Keebellah is offline Keebellah is a Trusted Advisor with special permissions. Keebellah has a Profile Picture
Computer Specs
Trusted Advisor with 5,281 posts.
 
Join Date: Mar 2008
Location: Oegstgeest, The Netherlands
Experience: Advanced
12-Sep-2011, 02:02 PM #2
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's Avatar
scotty718 scotty718 is offline
Member with 185 posts.
 
Join Date: Nov 2010
Experience: Intermediate
12-Sep-2011, 03:17 PM #3
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.
Attached Files
File Type: xlsm Data example.xlsm (23.6 KB, 92 views)
Keebellah's Avatar
Keebellah   (Hans) Keebellah is offline Keebellah is a Trusted Advisor with special permissions. Keebellah has a Profile Picture
Computer Specs
Trusted Advisor with 5,281 posts.
 
Join Date: Mar 2008
Location: Oegstgeest, The Netherlands
Experience: Advanced
12-Sep-2011, 04:17 PM #4
Okay. I'll check it, first I have to see the match Nadal-Djokovic!!! (I'm for Nadal)
Rollin_Again's Avatar
Member with 4,694 posts.
 
Join Date: Sep 2003
Location: Atlanta, GA - Planet Earth
Experience: Advanced
13-Sep-2011, 09:03 PM #5
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
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
WELCOME TO TECH SUPPORT GUY!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.


Tags
delimiters, excel, macro, split, text to column

(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑