Hi,
I have an output, e.g column A, which contains a text output but also characters that I want to get rid of e.g *,;*:,/ as well as the presence of any tabs or carraige returns.
Sample text (A1) shows exactly as
Mr A Smith
13 Jones Road;
Bicester,BS11
I need to change this to (into column B) as
Mr A Smith 13 Jones Road Bicester BS11
I have searched in vain and time is now against me.
Any help gratefully received.
Thanks.
G.
I have an output, e.g column A, which contains a text output but also characters that I want to get rid of e.g *,;*:,/ as well as the presence of any tabs or carraige returns.
Sample text (A1) shows exactly as
Mr A Smith
13 Jones Road;
Bicester,BS11
I need to change this to (into column B) as
Mr A Smith 13 Jones Road Bicester BS11
I have searched in vain and time is now against me.
Any help gratefully received.
Thanks.
G.