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

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