How to clean and convert data into columns using VBA

[satish78]

Hi Friends,

I been trying from few hours to clean and convert data into columns using excel formula.
But its taking much to process huge data.
I want take into different columns Like

ColumnA	ColumnB	ColumnC	ColumnD
First Name	Last Name	Job title	Company name

Sample data sheet attached

Hightail Spaces

Hightail Spaces lets you send unlimited files, of any size, to anyone. Collaborate with your team and evolve your work.

spaces.hightail.com

 

[yky]

Use Text to Columns feature and hyphen as the delimiter. This will give you three columns - name, job title, company name.
Copy name to, say, column G, and do another Text to Columns. This time, use space as the delimiter. This way, you separate first name from last name.
Because your data is somewhat irregular, you get maybe 90% of what you want.