Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I convert many rows of hyperlinks to BASE links?
Hi, there!
I have a spreadsheet consisting of several hundred rows, and in Column F of each row is a hyperlink consisting of the word "detail." Each of these hyperlinks represents a base link consisting of different US bicycling clubs. I would like to convert all of these hyperlinks back to their base links and can do it one at a time, but this is not efficient and will take forever. Im thinking that theres a formula I can write in a new column on each row of the spreadsheet that is capable of extracting the base link info in the €śdetails€ť column, and converting it to the actual base link in the new column. Ideally, I would be able to "copy" this formula all the way down the new column to reveal all the base links for each of the cycling clubs at one time, but this means the formula would have to be devised so it can pull the specific info pertaining to each cycling club in each row. Ive taken a brief look at €śformulas€ť under €śHelp€ť on the tool bar, but Im still not sure how to do this, or if, in fact, its do-able at all. If anyone can assist me with this, I'd greatly appreciate it! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I convert many rows of hyperlinks to BASE links?
hi
could you post some example of your data. that would help. Regards FSt1 "EnduroGal" wrote: Hi, there! I have a spreadsheet consisting of several hundred rows, and in Column F of each row is a hyperlink consisting of the word "detail." Each of these hyperlinks represents a base link consisting of different US bicycling clubs. I would like to convert all of these hyperlinks back to their base links and can do it one at a time, but this is not efficient and will take forever. Im thinking that theres a formula I can write in a new column on each row of the spreadsheet that is capable of extracting the base link info in the €śdetails€ť column, and converting it to the actual base link in the new column. Ideally, I would be able to "copy" this formula all the way down the new column to reveal all the base links for each of the cycling clubs at one time, but this means the formula would have to be devised so it can pull the specific info pertaining to each cycling club in each row. Ive taken a brief look at €śformulas€ť under €śHelp€ť on the tool bar, but Im still not sure how to do this, or if, in fact, its do-able at all. If anyone can assist me with this, I'd greatly appreciate it! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I convert many rows of hyperlinks to BASE links?
Hi,
What exactly do you mean by base link? -- If this helps, please click the Yes button. Cheers, Shane Devenshire "EnduroGal" wrote: Hi, there! I have a spreadsheet consisting of several hundred rows, and in Column F of each row is a hyperlink consisting of the word "detail." Each of these hyperlinks represents a base link consisting of different US bicycling clubs. I would like to convert all of these hyperlinks back to their base links and can do it one at a time, but this is not efficient and will take forever. Im thinking that theres a formula I can write in a new column on each row of the spreadsheet that is capable of extracting the base link info in the €śdetails€ť column, and converting it to the actual base link in the new column. Ideally, I would be able to "copy" this formula all the way down the new column to reveal all the base links for each of the cycling clubs at one time, but this means the formula would have to be devised so it can pull the specific info pertaining to each cycling club in each row. Ive taken a brief look at €śformulas€ť under €śHelp€ť on the tool bar, but Im still not sure how to do this, or if, in fact, its do-able at all. If anyone can assist me with this, I'd greatly appreciate it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formulat to convert base 32 to decimal? | Excel Worksheet Functions | |||
Excel hyperlinks:files to link on several base paths | Excel Discussion (Misc queries) | |||
convert a nine digit number to base 32 | Excel Worksheet Functions | |||
how do I convert numbers to a different base in Excel? | Excel Worksheet Functions | |||
Convert Works 6.0 data base to Excel? | New Users to Excel |