Remove Text before URL formula

[gospelsoulcare]

I am trying to figure out how to create a formula that would remove the text before a URL in a field.

Example:

Website: http://2pillarschurch.com

How do I remove the Website: portion so it just shows the URL?

[sohail]

You could do this a number of different ways. Easiest thing would be to create a new field that uses a formula to remove the "Website:" part. 

So if you have a field that has "Website: https://airtable.com" and is named "Website Info", create a new field that you name "URL" or something like that and use this formula: 

MID({Website Info}, FIND("http", {Website Info}), LEN({Website Info}))

[seferiannie]

assuming Website: http://2pillarschurch.com (websites) are in field URLFIELD, in the new formula field, add this:

MID(URLFIELD,9,16000)