Search : in
By :

Using Formula to Pull Data Out of Worksheet

Last answer on Aug 18, 2009 2:06:34 am BST excel234, on Aug 17, 2009 6:20:25 pm BST 
 Report this message to moderators

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.

Configuration: Windows XP Internet Explorer 8.0

Best answers for « Using Formula to Pull Data Out of Worksheet » in :
Backup Outlook 2003 data ShowBackup Outlook 2003 data All Outlook 2003 data ( Emails, Agenda, Contacts, Tasks...) are in one file with .pst extension The file is in the following default folder: C:\Documents and Settings\Login\Local Settings\Application...
Transferring data from one hard drive to another ShowTransferring data from one hard drive to another First of all you should use some tools.. transfering data from one hard drive to another is quite simple. Once you have connected the new hard drive to your pc, check your...
[Ingres] Importing/ Exporting data Show[Ingres] Importing/ Exporting data Making use of these commands copydb unloaddb Notes Ingres allows you to export data from an Ingres installation to another (it is a platform independent procedure). unloaddb copydb The main...
Data transmission - Cabling ShowCabling types Several physical data-transmission media are available to connect together the various devices on a network. One possibility is to use cables. There are many types of cables, but the most common are: Coaxial cable Double twisted...
Data transmission - Introduction ShowData representation The purpose of a network is to transmit information from one computer to another. To do this, you first have to decide how to encode the data to be sent, in other words its computer representation. This will differ according to...
OOP - Data encapsulation ShowThe concept of encapsulation Encapsulation is a way of organising data and methods into a structure by concealing the the way the object is implemented, i.e. preventing access to data by any means other than those specified. Encapsulation...
Ask your question Reply

1

 venkat1926, on Aug 18, 2009 2:06:34 am BST

NOT CLEAR. If URL is in A1 . the formula in an empty cell
=right(a1,4)
will give you the four numbers .

   
Reply to venkat1926
Ask your question Reply
They need your help