#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 6
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 6
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Newbie Formula Question - how to get formula to repeat in each subsequent row? [email protected] New Users to Excel 2 January 10th 10 05:02 PM
Formula Question Sarah Excel Worksheet Functions 0 September 25th 08 05:02 PM
Newbie Question - Subtraction Formula Question [email protected] Excel Discussion (Misc queries) 3 May 5th 06 05:50 PM
formula question Fiona Excel Discussion (Misc queries) 3 September 29th 05 02:31 PM
formula question imjustme Excel Discussion (Misc queries) 1 September 1st 05 06:16 PM


All times are GMT +1. The time now is 09:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"