Quote:
Originally Posted by Kevin@Radstock
Hi Jayjones
Assuming your data is in A1:
=SUBSTITUTE(A1,RIGHT(A1,5),"XXXX"&RIGHT(A1,1)) and copy down.
kevin
|
Hi Kevin, thank you so much - wouldn't have thought about combination. Wish I had posted this sooner!