Using Formula to Pull Data Out of Worksheet [Closed]

Report
Posts
1
Registration date
Sunday August 16, 2009
Status
Member
Last seen
August 17, 2009
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
Hello, I'd like to pull 4 numbers out of a list of URLS in a spreadsheet. The 4 numbers will always be in the same place at the end of the URL. I need to have a list of these URLs.

1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
800
NOT CLEAR. If URL is in A1 . the formula in an empty cell
=right(a1,4)
will give you the four numbers .
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!