Copy and custom format cell

[emel24]

Hi All,

How can I copy a cell from one worksheet to another (eg. ='00.Cover
'!C8) and have the text "Job No" showing infront of the copied
number/test?

Thanks in advance for your help.

 

[Dave Peterson]

How about:

="Job No"&'00.Cover'!C8)

Check the worksheet name. There was a line break in the formula in your
original post.

 

[emel24]

Thank you very much Dave. Your help is appreciated!