HELP WITH FORMULA

L

Leon

Is there a formula which I can use to strip out a particular character from a
text string? I have been sent a database with addresses in one of the
columns. The data has presumably been copied from a capture program and where
some fields were empty then an asterisk is reflected eg. 4 LINGFIELD
CLOSE,*,*,*,MILNERTON RIDGE,7441. I want the result 4 LINGFIELD
CLOSE,MILNERTON RIDGE,7441
 
T

thechilipino

Hello Leon -

If the text pattern you want to replace is consistent, i.e. always ",*",
you can use find and replace (ctrl-h), replacing ",*" with a blank space.

I hope that helps.

Cheers.
 
L

Leon

Thanks,

thechilipino said:
Hello Leon -

If the text pattern you want to replace is consistent, i.e. always ",*",
you can use find and replace (ctrl-h), replacing ",*" with a blank space.

I hope that helps.

Cheers.
Click to expand...
 
Top