Text To Column Parsing

Leventcos21

New Member
Joined
Nov 10, 2005
Messages
5
Hi,
I am trying to parse a column that has first name, last name and Company all in one column.

I was able to parse the fname and last name.

How can I parse the Company into it's own field.

Hint- The company name does not have a ",". How can I tell Excel to parse a field that does not contain a ",".
Thank you
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Leventcos21

New Member
Joined
Nov 10, 2005
Messages
5
Hi,

The field is CName and it contains this type of data

Mouse, Mickey
Duck, Donald
Disney World
Mouse, Minnie
Epcott Center
Duck, Daffey
WB Studios

I was able to Parse the name into CFName and CLNAME

but how do I parse the Company names that do not contain (,) into CCompany

Thanks
 

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
Welcome to the Board!

You can use Data-->Text to Columns-->Delimited-->Select Space and Comma.

Hope that helps,

Smitty
 

Leventcos21

New Member
Joined
Nov 10, 2005
Messages
5
Yes, I did try and was able to separate the names but when I do space for the Company, it splits it up into different columns

What I get with Text to Column

CName
Walt Disney

CCompany
Walt

Field J
Disney

Result that I want
CNAME
Walt Disney

CCOMPANY
Walt Disney
 

Forum statistics

Threads
1,137,125
Messages
5,679,769
Members
419,855
Latest member
Eddier32

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top