| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HELP WITH FORMULA
Thanks,
"thechilipino" wrote: 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. "Leon" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
