Separate a field into 5 fields

J

Janice R

I have a string of numbers that looks like "A3 000012691
100 605 00" in a column called Acct ID. I need to
separate this string into five differenct columns. The
space between the numbers is where the split needs to
be. THe new columns names are Bank Acct, Client ID,
SubAcct, Object, and Extra. What formula should I use?
I am more familiar using the query design screens than
the sql screen to write my formulas.
 

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

Formula to fill in fields when cell is blank 2
If conditions 1
VBA vlookup error depending on text string & quotation marks 2
create new table from Multiple Criteria in multiple columns 3
Parsing 1 field to 7 - divided by "/" 4
Can I split a string or use the split function in design view? 3
Left Join Question 2
2 functions 1 field in an append query 1

Top