Excel Formula Construction - What is _GoBack?

I was creating a text concatenation formula and wanted to concatenate cell A1 and B1 and I got _goback.  I can't find the documentation for this command anywhere.

=B1&_GoBack
brothertruffle880Asked:
Who is Participating?
 
barry houdiniConnect With a Mentor Commented:
Are you sure that _GoBack isn't a named range in your workbook?  On formulas tab look under "Name Manager"

regards, barry
0
 
NBVCCommented:
The only reference I could find is http://au.answers.yahoo.com/question/index?qid=20100925001917AAXoraS

So not to sure if it might be because of a problem with Named ranges you have/had?

Is that possible?
0
 
brothertruffle880Author Commented:
Definitely not a named range.  This is a brand new worksheet.  I just took some text data that I imported from a TXT file (downloaded from a mainframe) and I wanted to use the ampersand symbol to concatenate the first name field and the last name fields.

I had a worksheet with text fields and I wanted to concatenate them using the Ampersand symbol, not the concatenate function, and when I navigated to A1, all of a sudden _goBack appeared in the cell.
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
NBVCCommented:
I am not sure then.  I have never seen it, and that link was the reference I found that had any mention.  So it does exist, I guess, but not sure what invoked it.
0
 
barry houdiniCommented:
OK, not sure what to suggest then....

....the behaviour you describe would be consistent with A1 being named _GoBack. If you type

=B1&

....and then navigate to A1 it would put the name of the range in there rather than A1.

Any excel function would contain brackets like (), hence why I presumed it might be a named range. Can you post the workbook?

regards, barry
0
 
barry houdiniCommented:
Could it be anything to do with this - some sort of XML tag in your imported data?

regards, barry
0
 
brothertruffle880Author Commented:
Barry:
Sorry for the delay in getting back to you.  I was out of town.
No XML here.  This did not happen in earlier versions.
I will post the workbook.
0
 
brothertruffle880Author Commented:
Yikes.
I can't reproduce the problem right now.  I'll have to repost this problem at a later date.  I definitely did NOT have a named range.  However when i navigated back to the previous cell,  _GoBack appeared suddenly.
Definitely something inside of Excel.
0
 
brothertruffle880Author Commented:
I'm closing this even though there isn't a resolution.  I can't reproduce this and when i do I will open up a new incident.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.