KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
Consider the following Excel sheet: A B C 1 ASX:ANZ ANZ:ASX http://www.site.com/page?id=ANZ:ASX 2 DOW:1234 1234:DOW http://www.site.com/page?id=1234:DOW 3 NASDAQ:EXP EXP:NASDAQ http://www.site.com/page?id=EXP:NASDAQ I need a formula for the B and the C column. In the B column I need the values of the A column to be split on : and the two resulting parts to be reversed, see the three examples. In the C column, I need the result from B to be added to a (hardcopy) URL ( http://www.site.com/page?id= ) to form a link. Who can help me out? Your help is greatly appreciated!
Tags (comma-separated)
Save Edits
Cancel