Have you any ideas about why is the location iink is being divided into 2 cells when i sent it from a sheet to another?

[mustafaalbasel]

have you any ideas about why is the location iink is being divided into 2 cells when i sent it from a sheet to another?

[mustafaalbasel]

i guess its because of the , comma in the script, so how can i avoid that please?

[Taifun]

You have that issue while writing to the spreadsheet, not while reading...
A comma is the delimiter between the different cells... try to surround the location with double quotes to see if this helps...

Taifun

[mustafaalbasel]

thanks so much yes double quotes make it working well