Apply LEFT & RIGHT function to column

[chrisellis250]

Hi all,

I have the following code, which is supposed to combine the values from column I and column AD:

Please Login or Register  to view this content.

When running the code it works, but I get a #NAME error in the worksheet, and the formula appears in column AF as =right('AD2',10)&left('I2',14) with the ' ' around the cell references

Any ideas why?

[Fluff13]

Remove the R1C1 as you are using A1 notation & not R1C1 notation in the formula

[chrisellis250]

Thank you!

[Fluff13]

You're welcome & thanks for the feedback.