|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 5th, 2010, 09:04 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula question
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
February 5th, 2010, 09:33 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula question
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
