Hi all,

Can anyone provide me with guidance.

I have a series of comma & space separated values in the format:-

542224452, 5422245#, 54222740, 54223425, 5422346, 542235, 54224140,
54224141#, 542244412, 542244413#, 542244414#, 542244415#, 542244416#,
542244417#, 542244418#.

I'd like use a find and replace function to find all the numbers ending in a
# and replace them with just the number (ie without the #) but in bold (or
another colour ie Red).

Any advice will be gratefully received.

Thanks in advance

Yandros