Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004

    Unanswered: full name separate into 3 fields

    Hey Guys. I have a field called name in the contact.xls file that contains the fullname. How do i separate the name into first , middle and last in an sql statement? here are some different examples. They all seem to have the same format which is a firstname space middle intitial "." then lastname

    Richard M.Rewser Jr.
    Laura L.San
    William M.Mackian
    Jon P.Gaynor II

    Thanks guys

  2. #2
    Join Date
    Oct 2005

    spliting cells - using formulas and vba alternatives

    see attached message for details of how to use formulas to split text and also how to use the vba alternative.
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts