Dear Excellers,

Please help! I have a requirement to remove an age from a field of data that contains a persons name and some other personal information. It is for a daily direct mail job we run and if I can remove this information it will save me a huge amount of time and headaches each day. The data looks like this:

Mr Joe Bloggs 69 Diabetes|Cholesterol levels screening score: 1.1 screening cost: 11.57 Include medical conditions cover|
Mrs Joanne Bloggs 62 Cholesterol levels|High blood pressure|Underactive thyroid|Lichen sclerosus|Vitiligo screening score: 2.05 screening cost: 99.5 Include medical conditions cover|
Mr John Smith 78 Depression screening score: 2.81 screening cost: 0 Exclude medical conditions cover|


Names have been changed to protect the innocent. I need to remove the age immediately after the name. All the info above is in column BC in my file, which is currently save as a CSV.

Thank you in advance!

Gregg