Prev: Running Sum
Next: Report with fixe number of records
From: lil lam on 23 Mar 2010 17:20
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.
From: KARL DEWEY on 23 Mar 2010 19:04
BACKUP DATABASE BACKUP DATABASE
Try this --
Replace([YourField], Chr(35), "")

--
Build a little, test a little.


"lil lam" wrote:

> 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.
> .
>
 | 
Pages: 1
Prev: Running Sum
Next: Report with fixe number of records