| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Seperating hyperlink address from viewable text
I have a list of 551 hyperlinked email addresses. Column A shows the persons
name, and the name is hyperlinked with the persons email address. I would like to figure out how to keep the person's name in Column A, and be able to view the email address as text in another column without having to type each one out individually (or go through each one and copy and paste from the Edit Hyperlink box). Is there a way to do this in MS Excel 2003 quickly? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| text not viewable | Excel Discussion (Misc queries) | |||
| Seperating Text from Columns | Excel Discussion (Misc queries) | |||
| Seperating text | Excel Discussion (Misc queries) | |||
| Moving rows with Hyperlink doesn't move hyperlink address | Excel Discussion (Misc queries) | |||
| Hyperlink-Programable replacement of Text with Its Actual Address | Excel Worksheet Functions | |||
Threaded Mode
