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.
 
Back
Top