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 :

18 Cheswick Way, Solihull, B90 4JA

<tbody>
</tbody>

But Pasting it to website form made it:

"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

<tbody>
</tbody>

 

[Abbas999]

Before your reply I search for "carriage returns in excel" on Google and the problem was solved. There was only 2k carriage returns out of 50K addresses. Anyway the credit goes to you. I was a newbie you have identified the problem and posted the simple solution. Thank you very much.

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?