Why is my formula returning an error?

So I have to combine two halves of a UK postcode (format ##a #aa) from columns B:J (which column they are in is different depending on the row) & I have decided on a formula I can apply column by column to eventually get them all. (There is non-numerical values in other columns you see)

I've started by pulling through the values from column J into a new column like so:
=IF(ISNUMBER(VALUE(LEFT(J62,1))),J62,"")

So now I am trying to concatenate the values in the new column (K) with the values in I if they meet the criteria to start working back, like so:

=IF(OR(ISNUMBER(VALUE(LEFT(J62,1))),(ISNUMBER(VALUE(RIGHT(J62,1))),K62&I62,"")))

Please please help, where am I going wrong?

I"m not a formula expert but I can tell you from personal experience that the evaluate formula tool included with Excel has helped me with problems I thought were complicated but turned out to be something simple.
https://support.microsoft.com/en-us/...6-a70aa409b8a7

Unfortunately the worksheet contains GDPR protected data; I will try this formula but I?m not able to see what?s different, many thanks in any case

Don't know what do you want to do, but please try

=IF(IFERROR(FIND(LEFT(J62,1),"0123456789"),0)+IFERROR(FIND(RIGHT(J62,1),"0123456789"),0)>0,K62&I62,"")

Regards.

If none of those work, we need a small sample sheet. Not real data... mock something up. It'll only take you a few seconds. Read the yellow banner (top)

Whilst I understand that you may be in a bit of a panic, don't tell us that it is urgent, please. All your helpers here are volunteers giving freely of their own time: you haven't paid a penny for any assistance you get here, therefore expecting any form of speed response or preferential treatment, or seeming to, is inappropriate.

Thank you for your understanding. I have removed the urgency notice from your thread title.

Moderator