extract numberic value from cell and combine and add symbol in new cell

Originally Posted by TMS

This is pretty much a duplicate thread: https://www.excelforum.com/excel-gen...nt-format.html

Please don't waste people's time by starting new threads for the same issue. And it is common courtesy to reply to the answers you have in your original threads. Ideally, mark them as solved and link to the new thread if you feel that is helpful.

Please note that its not a duplicated thread, two thread clearly states different ways to get different results, one is extracting and one is removing duplicates.! I respect the forum and anyhow i wont waste forum space