Hi Roger,

i have copied the B4 formula into B4 (after moving my data into A4) and
pressed enter and i still get the #VALUE! message. I can only assume that i
don't have 'line feeds' although i have no idea what they are to be frank.

if the formula did work i would need to apply it to lots of data as well.

Kind regards