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?

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)

"kmhog" wrote:

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?

Thank you! I was completely brain farting! Thanx again!

"Ryan Poth" wrote:

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)

"kmhog" wrote:

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?