How do I get Christian Name and Surname separated?

  • Thread starter Thread starter John O'Gorman
  • Start date Start date
J

John O'Gorman

I have a Database with all the names as
"Christian Name Surname". How do I separate these into
two fields?

Many Thanks

John O'Gorman
 
Check out the Mid, Left, Right, InStr, and InStrRev functions. They are
commonly used functions to parse text strings.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Comparing two columns 1
End with... 3
Joining two tables 2
Trim a cell that has names and address to only show name 8
Cross reference two worksheets to identify matches 4
VLOOKUP with more than one possible response 2
merge docs using word 2003 1
Reversing the position of people's names in a cell 8

Back
Top