On May 2, 7:51 am, Colin G wrote:
Thanks Pete, I did try it like that as well but had exactly the same outcome.
Equally, when trying it like that on a new spreadsheet it worked!!

Well, a #VALUE! error means something it is trying to calculate is
text instead of a value. But your CONCATENATE formula (either version)
ought to still work, even if B4 is text. Since it is a text function.

Was the old file created in an older version of Excel? There are all
sorts of little glitches in old files that pop up after you upgrade.