Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
We have a spread sheet - htm - end project will be working with 90,000
records - broken into about 90 different spreadsheets... ColumnA - will be hyperlinked to column K Column A will contain a ID number - 15 numbers Column K will contain --- c:\(the same 15 numbers as above).pdf Column A should read... =hyperlink(K1, "the 15 numbers") questions - I've been playing with this all day and can't quite get it to work... Can I somehow pull those 15 numbers out to represent the friendly name? (from between the c:\ and the .pdf ) IF I could do that - then I should be able to "copy down" the formula to fill in the rest of the sheet? If anyone has any ideas that might help me - I would sure appreaciate some help!!! thanks in advance for your time!!! Cindy -- Cindy B |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Never mind... after posting this, I realized that I can simply add a column
with just the 15 numbers - and my problem is solved.... Ugh.... thanks for making me think! -- Cindy B "Cindy" wrote: We have a spread sheet - htm - end project will be working with 90,000 records - broken into about 90 different spreadsheets... ColumnA - will be hyperlinked to column K Column A will contain a ID number - 15 numbers Column K will contain --- c:\(the same 15 numbers as above).pdf Column A should read... =hyperlink(K1, "the 15 numbers") questions - I've been playing with this all day and can't quite get it to work... Can I somehow pull those 15 numbers out to represent the friendly name? (from between the c:\ and the .pdf ) IF I could do that - then I should be able to "copy down" the formula to fill in the rest of the sheet? If anyone has any ideas that might help me - I would sure appreaciate some help!!! thanks in advance for your time!!! Cindy -- Cindy B |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Newbie Formula Question - how to get formula to repeat in each subsequent row? | New Users to Excel | |||
Formula Question | Excel Worksheet Functions | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
formula question | Excel Discussion (Misc queries) | |||
formula question | Excel Discussion (Misc queries) |