Excel – How to extract partial data?

Last update on November 2, 2009 10:54 AM by aakai1056
Published by aakai1056

Excel – How to extract partial data?




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 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?

Solution


Suppose the hyperlink is in A1 in c1 (or any other cell in row 1)
  • Type this formula:

=RIGHT(A1,LEN(A1)-21)

So, suppose other hyperlinks are in A2 A3 etc copy C1 down

Note


Thanks to venkat1926 for this tip on the forum.
Best answers for « Excel – How to extract partial data? » in :
EXCEL: The INTERSECTION function ShowEXCEL: The INTERSECTION function You have a table consisting of rows and columns. Want to know the value of the cell at the intersection of a particular row / column in your table Example: Your table: - starts C3 to F3 ... for...
Avoid duplicates in Excel ShowAvoid duplicates in Excel In order to avoid duplication when encoding in a column from an excel sheet: take the conditional format on the first cell under the headings (eg A2) choose the following formula:...
[Excel] – Countif Formula Show[Excel] – Countif Formula Issue Solution Note Issue I have one excel file in that Column "B" has the "pending or Closed" Status and Column "C" has "Severity 1, Severity 2 and Severity 3" I want to count in one cell with "Pending...
Download Excel Viewer Show
Download EASEUS Partition Master ShowEaseUs Partition manager Free, is software "par excellence". EaseUs Partition Manager easily and without error will resize your hard disk partition into any size you chose: Main characteristics of EaseUs Partition Free: Material support for...
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...
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...
Spreadsheets - The Excel Interface ShowExcel Introduction Microsoft Excel is the spreadsheet in the Microsoft Office office suite. To start it, simply click on the appropriate icon in the Start menu (in Windows) or click on an Excel file (that has an .xls file extension). A Excel...
They need your help