Hi! I saw your website and found it really useful. I'm working on a website and need to import a list of Italian Cities and States from Excel into a database. The list has three columns and they are formatted as shown below. What I need is a formula for Column C to automatically create the URL formed as B2+B3+A3 (COUNTRY/STATE/CITY1...2...3..ETC...) and also include the / between all entries to create an URL. Please see the example excel file to get better the point!
I hope you can help me as it's dirivng me crazy!! thank you so much!
COUNTRYCOUNTRY
CITYCOUNTRYCOUNTRY/STATE
CITY1STATECOUNTRY/STATE/CITY1
CITY2STATECOUNTRY/STATE/CITY2
CITY3STATECOUNTRY/STATE/CITY3
CITY4STATECOUNTRY/STATE/CITY4
CITY5STATECOUNTRY/STATE/CITY5
I hope you can help me as it's dirivng me crazy!! thank you so much!
COUNTRYCOUNTRY
CITYCOUNTRYCOUNTRY/STATE
CITY1STATECOUNTRY/STATE/CITY1
CITY2STATECOUNTRY/STATE/CITY2
CITY3STATECOUNTRY/STATE/CITY3
CITY4STATECOUNTRY/STATE/CITY4
CITY5STATECOUNTRY/STATE/CITY5