Remove numbers from text string in one cell

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

Mind = Blown!

Thank you so much for quick and excellent reply, it works! However, I forgot to mention that in another file, exactly the same format, I need to strip all the info out apart from the age you have so kindly just helped me to remove. Is that a tweak to the above formula or another task entirely?

Thanks again.

Gregg