Separating Information in a single cell

[ejgallagher]

Hi All,

Here is my problem. I have a census of about 500 names with first and last in the same column. These need to be separated into 2 cloumns. Is there a quick formula that will separate these as retyping will take some time? If it would help the names are last comma first. Can I base the formula off of the comma?

Also - using right or left will not work as the names are all different lengths.

Thanks in advance!

Ed

 

[Aladin Akyurek]

You can use Data|Text to Columns (with comma as delimiter) instead of a formula.

 

[Egress1]

Aladin shows you the easiest way to do what you want. But just for your future reference this will show you how you could also use formulas to parse your text of varying lengths

Book1.xls
	A	B	C	D
1	Doe,John	Doe	John
2	Johnson,Randolph	Johnson	Randolph
3	Lincoln,Abraham	Lincoln	Abraham
4	Kennedy,John	Kennedy	John
Sheet2