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?

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?
image
image



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

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

thanks so much yes double quotes make it working well

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.