Something simple i hope

[PM1]

I have 3 Columns in a sheet that contains 16000 lines.

Col A = Passenger Name
Col B = Surname
Col C = First Name

Col A is polpulated as thus:-

STELLA/NICOLETTA MS
STELLA/NICOLETTA MS
MAILLARD/BENOIT MR
PROT/VINCENT MR
KHOORI/SAIF MR
JAMIL/SANIYA MS
HOWES/ANTHONY MR
MCCALLUM/GRAEME MR
LEVET/JACQUES MR
STELLA/NICOLETTA MS

How can I get the Srname and First Names into Col B&C. They are differenated in Col A by /

so I should have:

PASSENGER NAME LAST NAME FIRST NAME
STELLA/NICOLETTA MS STELLA NICOLETTA MS

 

[Special-K99]

Use Text To columns
with a separater of /

Text To columns is under the Data menu.

Copy/paste column A first if you want to keep it

 

[Jonmo1]

Copy/paste column A first if you want to keep it

Or select column B as the Destination during the Text To Columns operation.

 

[PM1]

That worked great - Thanks