Possible to extract partial data in Excel?
Solved/Closed
Related:
- Possible to extract partial data in Excel?
- Macro to extract specific data from excel - Forum - Excel
- Vba code to search data in excel - Guide
- How to transfer data in excel from one sheet to another - Guide
- How to auto update data in excel from another worksheet ✓ - Forum - Excel
- Partial match in excel - Guide
1 reply
venkat1926
Jun 19, 2009 at 07:49 PM
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Jun 19, 2009 at 07:49 PM
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
=RIGHT(A1,LEN(A1)-21)
suppose other hyperlinks are in A2 A3 etc copy C1 down
Jun 20, 2009 at 11:42 AM