help with delimiter (1 Viewer)

[aftershokk]

I have a column with a full name as follows.

DRISCOLL MD,EDWARD F

I want to split into 2 columns. Anything to the right of the comma would be first name and anything to the left would be last name. I would not include the comma in the new columns.

thanks!

 

[Dennisk]

use the INSTR function. This will give you the position of any character in a string.

The use the Left$ function and Right$ function to get the two fields

 

[Peter Reid]

Alternatively, look at the SPLIT function