Split a user name in to three parts from an excel field?

[mrmiyagi]

Hello,

I want to split a user name like "Smith, John [ACME]" (in cell A2) in to three parts in three different cells First Name = "John" (B2), Second Name "Smith" (C2) and company "ACME" (D2).

How can I do this?

Thank you.

 

[Dazzawm]

Can you use text to columns using space as the delimter?

 

[VoG]

Try

Excel Workbook
	A	B	C	D
2	Smith, John [ACME]	John	Smith	ACME
Sheet5

 

[mrmiyagi]

Try

Excel Workbook
	A	B	C	D
2	Smith, John [ACME]	John	Smith	",A2)-FIND("-1)]ACME
Sheet5

Thank you.