View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
S. Malik S. Malik is offline
external usenet poster
 
Posts: 2
Default Hyperlink values

Hi,

I have got a column with certain values with each value pointing to a web
address. Now what I need done is, get the values in one columns and links in
other colums. For e.g: In A1, I have "Ben's Kitchen" hyperlinked to
"www.example.com", I want A1= Ben's Kitchen; B1=www.example.com

Any ideas or suggestions?

Thanks very much in advance.

S. Malik