Create an excel formula to merge a Lat and Long into an internet URL

I am coding thousands of listings into a website and I want to merge lat and long data into a website url.

I need a formula written that I can merge a latitude and longitude ref into a website URL using data contained in two cells (Lat And Long) in an excel sheet.

I then want to drag the code down the sheet creating 1000's of different urls with different Lat and long references.

I know how to then special paste a code to get the value rather than the formula to create the url, I am just struggling to merge these two bits of data.

I will provide the URL to the winner of the work. This job should take 10 minutes for someone who is proficient in Microsoft Excel.

Taidot: tiedonsyöttö, tietojenkäsittely, Excel, Microsoft Office, Visual Basic

Näytä lisää: excel split url into columns, excel to kml, excel to kmz file google earth, import excel into google earth, excel to kml converter offline, excel to kml tool, embed google map in excel 2016, how to transfer a hyperlink with vlookup, call web service excel formula, create internet macro excel, excel formula convert utm lat, converting utm lat long excel, convert utm lat long excel, excel formula create digit luhn number, excel macro search copy data internet explorer excel, create excel formula, how to create a formula in excel for multiple cells, how to create a formula in excel 2016, excel formula create email address first initial last name, how to create a formula in excel

Tietoa työnantajasta:
( 0 arvostelua ) Hurstbourne Tarrant, United Kingdom

Projektin tunnus: #19000512

Myönnetty käyttäjälle:


Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me. Roy

£13 GBP 0 päivässä
(308 Arvostelua)

7 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Please send me the Lat and Long data, and will send back the formula in 10 minutes. I am ready to start right away. Thanks,

£18 GBP 1 päivässä
(204 arvostelua)

hi sir, i will merge the lat and long to the url so that a target url can be generalted in a cell for each of the rows containing lat and long, you can drag to any number of rows needed, will do in 5 mins right now, th Lisää

£10 GBP 1 päivässä
(320 arvostelua)

Good Day, I am willing to take responsibility for your project too! Please let me know, if you want my services. Thanks Emamul H.

£18 GBP 1 päivässä
(66 arvostelua)

Hello, I am experienced excel expert. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards Rina B.

£18 GBP 1 päivässä
(80 arvostelua)

Hello, I am Oracle certified professional java programmer and have BSC.IT. I am working with excel for last few years. I am ready to help you now. You can pay after success. Please provide more details. Thank you.

£18 GBP 0 päivässä
(39 arvostelua)

Hello! I’ve read your job description & I am very much interested in working on your project. I have a good experience of the works. I am the right candidates for this task. I am a quick, reliable and efficient work Lisää

£18 GBP 1 päivässä
(14 arvostelua)