Find and Replace in Access 2007

  • Thread starter Thread starter lil lam
  • Start date Start date
L

lil lam

I have address columns:

705 First St #5

804 Main St #16

I just want to remove the pound (#) signs.
How do find/replace for just the #?

I tried the Replace Function but it deletes the entire cell.
I also tried the RemoveAlpha but I get an error saying its an
undefined function.
 

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

Access Access 2007 Delete Part of Text 0
replace text in a string 6
How do I replace just a few characters? 3
Access #Error & Excel Pivot 0
DoCmd Find and Replace 5
changing signs in formulas and cells 1
Replace and Find 1
Removing characters 2

Back
Top