Strange formatting issue - Help Needed.

[Abbas999]

Hi Experts I have a very strage issue. I have sheet with muptiple addresses. When i copy and paste the addresses from excel to a website form It doubles the value. For example.
The address is : [TABLE="width: 254"]
<tbody>[TR]
[TD="width: 254"]18 Cheswick Way, Solihull, B90 4JA[/TD]
[/TR]
</tbody>[/TABLE]

But Pasting it to website form made it:[TABLE="width: 254"]
<tbody>[TR]
[TD="width: 254"]"18 Cheswick Way,
Solihull, B90 4JA"

So website website form count it as 2 addresses. Also the "" are not showing in excel but when i copy a address and paste it into web form it always show a " at start and end of a address. Please Suggest me a solution. Thank you[/TD]
[/TR]
</tbody>[/TABLE]

 

[steve the fish]

What happens if you put an address in from any other source? For example copy pasted from notepad, word, etc etc. Maybe copy the address you have posted above and paste that into the website. I doubt this has anything to do with excel.

 

[Abbas999]

I tried it pasting first to notepad then to web form - Not working same results
I tried pasting it to other documents and then to web form - same results not working.
I tried to copy all address from excel to another excel sheet and pasted it as PASTE special only values and then copying to web form. Not working.

You can see the pic below the addresses looks very good in excel cells :

But copying it and pasting here will double the addresses:
For example i pasted the same addresses here as shown in the pic:
[TABLE="width: 346"]
<colgroup><col></colgroup><tbody>[TR]
[TD]19 Correction Wynd,
Aberdeen, AB10 1HP[/TD]
[/TR]
[TR]
[TD]44-48 Great Western Road,
Aberdeen, AB10 6PY[/TD]
[/TR]
[TR]
[TD]349 Great Western Rd,
Aberdeen, AB10 6NW[/TD]
[/TR]
[TR]
[TD]Caledon Lounge, Garthdee Rd,
Aberdeen, AB10 7AP[/TD]
[/TR]
[TR]
[TD]7 Little Belmont St,
Aberdeen, AB10 1JG[/TD]
[/TR]
[TR]
[TD]44-48 Great Western Road,
Aberdeen, AB10 6PY[/TD]
[/TR]
[TR]
[TD]122 Huntly Street,
ABERDEEN, AB10 1SU[/TD]
[/TR]
[TR]
[TD]77 Skene St,
Aberdeen, AB10 1QD[/TD]
[/TR]
[TR]
[TD]529 Great Western Rd,
Aberdeen, AB10 6PE[/TD]
[/TR]
[TR]
[TD]21 Rose St,
Aberdeen, AB10 1TX

You can see they are double now. Please suggest a solution. Thanks[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

What happens if you put an address in from any other source? For example copy pasted from notepad, word, etc etc. Maybe copy the address you have posted above and paste that into the website. I doubt this has anything to do with excel.

 

[Abbas999]

Anyway Have a solution?

 

[steve the fish]

Sorry but it seems any fault lies in the form not excel. What is the website address?

 

[Abbas999]

@steve the fish "To me it looks like excel formating error as first 4000 addresses were not having the issue as i just copy pasted the addresses to website form and it was all fine. You can see the picture all remaining addresses have the same problem. If excel have no problem then it should also have the same error for first 4,000 addresses.

Sorry but it seems any fault lies in the form not excel. What is the website address?

 

[Abbas999]

Website url - Batch geocoding

one more thing - if i copy the addresses from excel to notepad it shows as single line. But if i copy the same single lines from notepad to a new spreadsheet as Paste Special "values only" it also behaves same as web form.

It is showing in notepad:
19 Correction Wynd, Aberdeen, AB10 1HP
44-48 Great Western Road, Aberdeen, AB10 6PY

You can see it is two cells in totals.

But if i copy these two addresses from notepad and paste into a newly created excel sheet it converts to 4 cells.

Result in excel sheet after pasting the 2 addresses from notepad.
19 Correction Wynd,
Aberdeen, AB10 1HP
44-48 Great Western Road,
Aberdeen, AB10 6PY

So it is 4 cells in excel sheet. This is the error i am getting. 20 addresses looks 40 and 40 convert to 80 and so on. I have around 50K addresses. Please suggest me a solution to reformat them. Thank you

Sorry but it seems any fault lies in the form not excel. What is the website address?

 

[steve the fish]

Do you have carriage returns in your addresses? Only time ive seen anything like that.

 

[Abbas999]

What does it means? Sorry I did'nt understand.

Do you have carriage returns in your addresses? Only time ive seen anything like that.

 

[steve the fish]

Highlight cells in question. Press CNTL-H. Click in the first box. Press CNTL-J. Leave the 2nd box empty. Press replace all. How many replacements does it make?