stefanoste78
Member
Good morning.
I have an excel file that contains addresses in column a. I'm using a system to obtain the geographical coordinates online which I copy next (coonna f of the file). I would like to insert in column "b" and "c" formulas like an index compare which by associating the two addresses then copy the geographical coordinates from column "f" and insert them in column "b" and "c".
Is it possible to fre so that the coordinates are pasted as text to avoid losing formatting?
Thank you
I have an excel file that contains addresses in column a. I'm using a system to obtain the geographical coordinates online which I copy next (coonna f of the file). I would like to insert in column "b" and "c" formulas like an index compare which by associating the two addresses then copy the geographical coordinates from column "f" and insert them in column "b" and "c".
Is it possible to fre so that the coordinates are pasted as text to avoid losing formatting?
Thank you