Solved Tab names with/without spaces in formulas???!!!

November 17, 2013 at 20:52:49
Specs: ?, ?
I don't remember in Excel 2007 a tab name with a space being treated differently in a formula than a tab name without a space? I thought I did it all the time and copied formulas and replaced tab names (either with spaces or without spaces) without any issues. In Excel 2010 I see the single quotes in formulas (around tab names using spaces) messing up my copy/paste/replace of just the tab name because the single quotes aren't used in a formula with a tab name that doesn't use spaces! Is this a bug???? It doesn't make any sense for a tab name to be treated differently in a formula no matter what the tab name is?!?!?!!

See More: Tab names with/without spaces in formulas???!!!

Report •

#1
November 18, 2013 at 13:25:05
✔ Best Answer
As far back as Excel 2000 I have always needed to surround a sheet name containing a space character with single quotes.

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question