Search : in
By :

Column to row, mailto: link

Last answer on Sep 18, 2009 8:34:44 pm BST sharkb88, on Sep 17, 2009 5:43:43 pm BST 
 Report this message to moderators

Hello,

I have a column of addresses, some are composed of 4 lines of information, others have 5. Each entry is separated from the next by a blank row. I would like to convert these from a column to one row containing all of the information on that address.

Davey Jones
123 Sesame St.
Mesa, AZ 85201
(602) 555-5555

Davey Jones, 123 Sesame St., Mesa, AZ, 85201, (602) 555-5555

The second part of my question involves converting a cell with a mailto: link to the value of the hyperlink. Example: it may display as Send me an e-mail (this is the hyperlink displayed), then clicking on the link opens an e-mail with the address already filled in. This address is what I would like to place in a cell.

Thanks for your help in advance!

Configuration: Windows XP
Firefox 3.5.3

Best answers for « Column to row, mailto: link » in :
EXCEL: The INTERSECTION function ShowEXCEL: The INTERSECTION function You have a table consisting of rows and columns. Want to know the value of the cell at the intersection of a particular row / column in your table Example: Your table: - starts C3 to F3 ......
Remove the border on an image in a link in HTML / CSS ShowRemove the border on an image in a link in HTML/CSS HTML You made a clickable image by using the IMG tag within a link and the browser displays a frame or more precisely a border around the image. There are two ways...
Transforming columns into lines ShowTransforming columns into lines Example Limitations It is endemic for most Linux tools to work with lines, but not with columns (sed, awk, grep, etc..). However, it may happens,that you have a file where the data should be read in...
Ask your question Reply

1

sharpman, on Sep 18, 2009 12:42:32 am BST

What version of excel are you using?

the email question can be done as follows in excel 2007

click on the insert tab in the ribbon,
click on hyperlink
select email address option (left hand side bottom)
type in the email address that you want in the email address field.
edit the 'text to display' to what ever you want displayed, ie 'Send me an e-mail'
click ok
the text to display will be in the cell that you highlighted to insert the hyperlink.

Now when when someone clicks on the link it will open their email client to send you an email.

Have a read here for the copy paste issue that you have raised
http://www.bigresource.com/VB-Help-with-Excel-Macro-Transpos­e-Cells-QwQh4VjeG9.html

   
Reply to sharpman

2

sharkb88, on Sep 18, 2009 7:27:04 pm BST

I am using Office 2007.

The question I had regarding the mailto: link was not how to create them, but how to uncreate them or place just the value of an existing link into another cell. Example: Say I had an Excel spreadsheet with a column containing some mailto: links that read "Click here and send me an e-mail", but wanted the actual e-mail address such as legacyfinancial@xyz.com that was associated with that link to be placed into another cell adjacent to the existing hyperlink. How could this be achieved?

   
Reply to sharkb88

3

 sharpman, on Sep 18, 2009 8:34:44 pm BST

Ok dude, I think what you are looking for is here
http://www.pcreview.co.uk/forums/thread-1066124.php

it works, i've just tried it

see how that goes

   
Reply to sharpman
Ask your question Reply
They need your help