• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Help! Create URL from Column Data

Matteo123

New Member
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
 

Attachments

  • EXAMPLE.xls
    25.5 KB · Views: 0
Finally managed modyfing the columns and using
Code:
=CONCATENATE(C1,B1,A1)
, the B column I did for every state a Replace function to change for example from State to /State/ .... Thanks for your reply anyway! Really useful function! THANK YOU!
 
Back
Top