How do I remove a dash?

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

Guest

I need to take out one dash out of a group of letters and dashes. Examples
are things from A-2, B-3-5-2, or even 12-7-4. I need the first dash taken out
of my entire database. Is there any type of query or anything to take this
out?
 
You could use the following in a query:

Left([MyField], InStr([MyField], "-") - 1) & Mid([MyField], InStr([MyField],
"-") + 1)

If you wanted to make the change permanent, you could use that in an Update
query.
 
You must log in or register to reply here.

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

Extracting data and Reformat 6
Remove Words and Set Length 11
insert a dash 5
How do I create a formula to remove dashes? 6
Removing non Alpha Numeric Characters 6
Regex. Digits, Letters and Dashes. what am I doing wrong? 6
Help on removing leading dash in business card view Outlook 2007 1
Removing dashes from a number 4

Back
Top