Pretty vague question. Please give us a better example. Do you want to
split it based on the number of characters (pull the first x characters to
one column and the other x characters to another?) Is it always the same
number of characters?
Do you want to pull the separate figures to two separate fields in a table
and then delete the original field? In other words, are you fixing some
data permanently?
Are you trying to do this in a table, query, or form?
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.