By this formula both
A2 should display the value of
Sheet Space!E8 &
Sheet Space!E9 cell respectively.
But as the
Sheet Space Worksheet has space in it's name and I can't add apostrophe
' to sheet name manually (as the sheet name is reproducing Dynamically).
Please note that I can't add apostrophe in C1 manually as
Sheet Space in
C1 also comes dynamically from another cell.
So how can I edit the formula so that It will not display