Find and Replace in Access 2007

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