Splitting Data from One field into 2

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

Guest

I know how to concatinate into one field, but is there a way to separate data
from one filed in to two?

For example the filed is Name: John Smith is there a way to make one field
John and the other Smith?

Thanks
 
do a search - asked and answered all the time. As previously posted, What
will you do with...

Jim St. Johns?

Mary Alice Smith

Phil Mac Cracken

Rick C. Jones


Almost no way to do this automatically.
 

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

Splitting data from one filed into 2 fields. 1
Separate Names 3
Excel Comparing two columns 1
Formating Address to Multple Fields 3
Combining firstname and lastname in combo box 6
Finding Numerics in a field 2
Join rows into one long row 4
Need query to fill in missing data on table 1

Back
Top