Is this in Excel (which has cells) or in Access (the subject of this
newsgroup)?
Depending on what's in them, it may be a simple substring operation,
or it may be like unscrambling eggs. Post more details (in one of the
Excel newsgroups, not here, if you're using Excel).
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.