Hi all,
I'm racking my brains to find I way to hide extra underscore "__" in a concatenate formula if one optional field left empty
2020_02-Jan_Client1_Finance_Cheese__ABCD_PI-123123
I managed to do with the formula below, however in different cells. I would like to add everything in the same cell.
=IF(SEARCH("__",C25),SUBSTITUTE(C25,"__","_"),"")
Also, with the formula above, if there's no "__" in the result, it returns #VALUE!
Does anyone have any idea how can I do that in one formula?
Thank you
Bookmarks