1

Topic: Transfer Codes starting with the symbol =

https://i.postimg.cc/D0GNPcSn/sheets-formula.png


I use Godaddy for a lot of my domains and they have a neat feature where you can download a spreadsheet of all your domains. You can customize the fields and if you download all of the fields it is shocking how much information it contains about each domain.

You can download the spreadsheet with or without the transfer codes which are placed in the last field if you request them.

I hate having a transfer code that starts with the = sign and I think it should be abolished as the first character in transfer codes. The spread sheets looks at it as a command and shows it as an error.

So every time I look at my spreadsheet I see a few errors unless I put something in front of the = sign but then the transfer code is no longer accurate.

Third world problems, I know but nonetheless problematic

2

Re: Transfer Codes starting with the symbol =

Use find/replace in Excel, which should solve that in a few seconds.

Candy is childhood, the best and bright moments you wish could have lasted forever. - Dylan Lauren

3

Re: Transfer Codes starting with the symbol =

Well, I'm not sure how that would work.  Find/Replace can't match ONLY equal signs at the front of a string.  And you'd want to retain the actual auth code that includes the =, not get rid of, change it, nor prefix it with a single quote either...

You _should_ be able to simply change the formatting of the cell to text and excel should then _not_ try and interpret it as anything but literal text only.  But it doesn't, unfortunately.  In my version of excel, I can create a new column, format it first as text, then I can type =lksdjflskdfjlskj in a cell and it doesn't interpret it as a formula.  This leads you to believe that if you formatted a blank column as text, then special pasted the column as text into the newly text formatted column, that it would do exactly that.  But for me, that doesn't work either.   Hand typing in the text formatted cells interprets it as only text like you'd expect (not interpreting it as a formula).  But "special paste" as text pastes it, but then it still interprets the equal sign as a formula again.  Counter-intuitive and frankly frustrating.  I'm using an older version of excel on my mac, maybe the latest version has fixed that?
  That method might at least be worth a try Frank....

4

Re: Transfer Codes starting with the symbol =

The escape function may work. For example, to put the text "=55DA" in a cell, type the text below in the cell.

'=55DA

The spreadsheet will not interpret as formula and automatically remove the single quotation. So same principle as placing something in front of the code, but in this instance spreadsheet will display correct code and automatically remove quotation.

5

Re: Transfer Codes starting with the symbol =

Nothing works for me, if it is a plain text field it removes the = and then it is the wrong code.
If I add something in front of the = then it is still the wrong code.

I am using google sheets but I know it is the same with Excel.

It's frustrating because with so many domains I simply download the data and always have to correct the code starting with = and it may be my look but I always have 5 or 6 of them.

6

Re: Transfer Codes starting with the symbol =

yeah, that was the point I was trying to make, you don't want to modify the actual auth code just to make it display properly - because when the time comes to transfer a domain, you're going to cut-and-paste it...

It's _truly_ a display issue which is why there should be some formatting function to fix it, but there is not...

Some registrars allow you to generate a new auth code any time you like.  If that is possible at GoDaddy - maybe just regenerate the auth codes that have equal signs at the front....

Liked by: jaydub

7

Re: Transfer Codes starting with the symbol =

rlm wrote:

Some registrars allow you to generate a new auth code any time you like.  If that is possible at GoDaddy - maybe just regenerate the auth codes that have equal signs at the front....

Not sure if they have that function but it is worth checking out.

8

Re: Transfer Codes starting with the symbol =

I don't have excel handy, but you should be able to use the replace function by escaping the "=" character with a backslash. So find:
\=
and replace it with something that works for you.

Also if the column is formatted as "text", shouldn't it ignore Formulas? Maybe not.

Domains Product Manager @WHC
(514) 504-2113 x7209