SQL / Excel question

MaggieL · 05-26-2006, 01:13 PM

He's talking about a cell like this:
=HYPERLINK("http://www.google.com","bigSearchEngine")

It would be easier if his data was like:

-+---------A------------------------ B-------------------------C
1| =HYPERLINK($B$1,$C$1) | "http://www.google.com" | "bigSearchEngine"

In fact, it would be trivial...his desired reference would be =B1. As it is, I'd be tempted to export the
formulas from column to a flat file and massage them with a text editor.

Gwennie gets paid to answer Office usage questions like this at PCHelps.

05-26-2006, 01:13 PM	#5
MaggieL in the Hour of Scampering Join Date: Jan 2001 Location: Jeffersonville PA (15 mi NW of Philadelphia) Posts: 4,060	He's talking about a cell like this: =HYPERLINK("http://www.google.com","bigSearchEngine") It would be easier if his data was like: -+---------A------------------------ B-------------------------C 1\| =HYPERLINK($B$1,$C$1) \| "http://www.google.com" \| "bigSearchEngine" In fact, it would be trivial...his desired reference would be =B1. As it is, I'd be tempted to export the formulas from column to a flat file and massage them with a text editor. Gwennie gets paid to answer Office usage questions like this at PCHelps. __________________ "Neither can his Mind be thought to be in Tune,whose words do jarre; nor his reason In frame, whose sentence is preposterous..." Last edited by MaggieL; 05-26-2006 at 01:21 PM.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)