Excel references to other sheets

K

kmhog

I am trying to fill in information in a "header" page and have the
information populate throughout the rest of the workbook. I am running into a
problem trying to add a space between the information from the "header" page.
ex. =(header!A2) & (header!A3)
How do I add a "forced" space between the two pieces of information?
 
R

Ryan Poth

This could be a case of "too easy, so I probably misinterpreted the
question", but does the following solve your problem?

=(header!A2) & " " & (header!A3)
 
Top