• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1754
  • Last Modified:

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
0
brothertruffle880
Asked:
brothertruffle880
  • 4
  • 3
  • 2
1 Solution
 
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
 
barry houdiniCommented:
Are you sure that _GoBack isn't a named range in your workbook?  On formulas tab look under "Name Manager"

regards, barry
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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 4
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now