Search : in
By :

Possible to extract partial data in Excel?

Last answer on Jun 20, 2009 4:42:49 pm BST DarkDMize, on Jun 19, 2009 9:39:40 pm BST 
 Report this message to moderators

Hello,

I have an Excel spreadsheet that contains around 1500 html links.

All the addresses start out common... i.e. http://www.frogs.com/. What I want to extract into another cell (or worksheet) is the uncommon part of the links. For example, http://www.frogs.com/bull_frogs
or http://www.frogs.com/tree_frogs.

Is there a way to automate this with a macro or something, or am I stuck doing each and every one manually?

Configuration: Windows XP Internet Explorer 7.0

Best answers for « Possible to extract partial data in Excel? » in :
Excel – How to extract partial data? Show Excel – How to extract partial data? Issue Solution Note Issue I have an Excel spreadsheet that contains around 1500 html links. All the addresses start out common... i.e. http://www.frogs.com/. What I want to extract into another...
Copying data from one Excel sheet to another. Show
Using excel if function with data validation Show
How to convert Excel into PDF? ShowHow to convert Excel into PDF? Here is a small tips about how to convert your excel files into PDF for your presentation. Step 1 PDF995 is software that gets installed on your computer which enables you to print any sources of document to...
Changing the label (name) of partitions. ShowChanging the label (name) of partitions All commands must be given as administrator (root mode). Give the simplest names possible to partitions (if possible only alphanumeric characters (a. .. z and 0 ... 9) and - and _. Partition...
How to Resize a Partition using Gparted on Linux? ShowHow to Resize a Partition using Gparted on Linux? You have a partition and you want to enlarge or reduce it without losing data? It is possible and relatively easy with GParted, a LiveCD, ie a bootable CD, providing an interface...
Download Data Manager for Excel ShowHave you already thought that your Excel worksheet can be transformed into a true database? Now, it is possible thanks to Data Manager for Excel. Data Manager for Excel is an add-in for Microsoft Excel allowing to transform the worksheets into...
Download SmartBackup for Smartphone ShowSmartBackup is a backup of contacts for your phone. Backups are stored on a web server, so your phone must be connected to the Internet via GPRS, Wi-fi or in a different way to copy or restore contacts. Advantage It is possible to compress data...
Download SystemRescueCd ShowSystemRescueCd is a Linux operating system complete with one difference is that it requires no installation. The system is on a bootable CD-ROM or "LiveCD" small. It can easily perform tasks on a machine. It is possible to partition the drive to save...
Partition - Partitioning a hard drive ShowWhat is a partition? The partitioning of a hard drive occurs after the drive has been physically formatted but before it is logically formatted. It involves creating areas on the disk where data will not be mixed. It can be used, for example, to...
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...
Binary encoding ShowIntroduction to binary In the late 1930s, Claude Shannon showed that by using switches which were closed for "true" and open for "false," it was possible to carry out logical operations by assigning the number 1 to "true" and 0 for "false." This...
Ask your question Reply

1

venkat1926, on Jun 20, 2009 12:49:13 am BST
  • +1

Suppose the hyperlink is in A1 in c1 (or any other cell in row 1) type this formula
=RIGHT(A1,LEN(A1)-21)
suppose other hyperlinks are in A2 A3 etc copy C1 down

   
Reply to venkat1926

2

 DarkDMize, on Jun 20, 2009 4:42:49 pm BST

Thanks! =)

   
Reply to DarkDMize
Ask your question Reply
They need your help