Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Display the complete URL instead of a link
Output from one of my software is in excel format. The results are
something like Name Title ID source score ABC rock-n-roll 123 link 92 ABC2 rock-n-roll2 124 link 65 ABC3 rock-n-roll3 125 link 45 The "link" in the source column has the actual URL to that album or file. For further processing I need to import this file as a csv and I need the actual URL displayed in the source instead of the "link" word. For example the URL is www.somewebsite.com/documentID=AA1234 some basically I want something like ABC,rock-n-roll,123,www.somewebsite.com/documentID=AA1234,92 ABC2,rock-n-roll2,124,www.somewebsite.com/documentID=AA1222,65 ABC3,rock-n-roll3,125,www.somewebsite.com/documentID=AA1256,45 Is there a way I can do this? Thanks a lot. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
removing automatic link | Excel Discussion (Misc queries) | |||
Paste Link - retaining formatting | Excel Discussion (Misc queries) | |||
Link Link Link | Excel Worksheet Functions | |||
Breaking the link | New Users to Excel | |||
Combine & Display “Fixed” & “Automatically Updated” Date Parts | Excel Worksheet Functions |