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.
 
Back
Top