Using Formula to Pull Data Out of Worksheet

Closed
excel234 Posts 1 Registration date Sunday August 16, 2009 Status Member Last seen August 17, 2009 - Aug 17, 2009 at 01:20 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 17, 2009 at 09:06 PM
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 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Aug 17, 2009 at 09:06 PM
NOT CLEAR. If URL is in A1 . the formula in an empty cell
=right(a1,4)
will give you the four numbers .
1