modify - deliminate - text in a query like Mary & John

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a list of names Husband & Wife - how would I separate the names when
the symbol & is used? I want to end up with a column His and next column Her

I just moved the column into excel & separated it there - but that was vert
time consuming.

Thanks for all you folks do - I find so many useful answers here
 
Husband: Trim(Left([NamesField], Instr(1,[NamesField], "&")-1))
Wife: Trim(Mid([NamesField], Instr(1,[NamesField], "&")+1))

This will only work if they are separated by an ampersand AND husband is
always first.
 
Back
Top