Forum Discussion
Excel formulas starting to include current sheet name
Hi I recently noticed that formulas in excel starting to automatically include the "current" sheet name after leaving and coming back to the sheet (example below). I don't remember this used to be ...
Hello,
For your information, this behavior has never changed. I just checked on Excel version 95 (1995).
I wasn’t claiming Excel behavior changed over time. The issue isn’t about versions at all — it’s about how Text to Columns works:
Text to Columns has always required a consistent delimiter.
The data in the Post does not have one:- Some rows use a comma → New Orleans, LA
- Others don’t → Los Angeles CA
- City names have variable spaces
So this isn’t a version problem — it’s a data structure problem. Even in Excel 95, Text to Columns would behave the same way.
The core rule
Excel can only split cleanly when:
There’s a consistent separator, OR a fixed position is defined.
The data has neither — but it does have one reliable pattern:
The state is always the last word.
