Copy and custom format cell

E

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.
 
D

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.
 
Top