Column to row, mailto: link
Closed
sharkb88
-
17 Sep 2009 à 12:43
sharpman Posts 1021 Registration date Saturday 23 May 2009 Status Contributor Last seen 20 October 2010 - 18 Sep 2009 à 15:34
sharpman Posts 1021 Registration date Saturday 23 May 2009 Status Contributor Last seen 20 October 2010 - 18 Sep 2009 à 15:34
Related:
- Column to row, mailto: link
- Saints row 2 cheats - Guide
- How to delete a row in word - Guide
- Excel column number - Guide
- Tweetdeck expand column - Guide
- Saints row pc download - Download - Action and adventure
2 responses
sharpman
Posts
1021
Registration date
Saturday 23 May 2009
Status
Contributor
Last seen
20 October 2010
183
18 Sep 2009 à 15:34
18 Sep 2009 à 15:34
ok dude, I think what you are looking for is here
https://www.pcreview.co.uk/threads/how-do-i-copy-the-underlying-e-mail-hyperlink-information-from-a.1066124/
it works, i've just tried it
see how that goes
https://www.pcreview.co.uk/threads/how-do-i-copy-the-underlying-e-mail-hyperlink-information-from-a.1066124/
it works, i've just tried it
see how that goes
sharpman
Posts
1021
Registration date
Saturday 23 May 2009
Status
Contributor
Last seen
20 October 2010
183
17 Sep 2009 à 19:42
17 Sep 2009 à 19:42
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-Transpose-Cells-QwQh4VjeG9.html
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-Transpose-Cells-QwQh4VjeG9.html
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?
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?
