Forum Discussion
Adding 1 to Every Number in Formula String
Hi All, I am working on many workbooks and for all of them, I am using conditional formatting for hundreds of cells. Specifically, I am using 7 different cell ranges, and the cells themselves are...
=TEXTJOIN({":".","},,LEFT(TEXTSPLIT(A4,{":".","}),SEARCH("$",TEXTSPLIT(A4,{":".","})))&TEXTNACH(TEXTSPLIT(A4,{":".","}),"$")+1)
With Excel for the web or Office 365 you can use this formula. The formula is filled down from cell A5. Perhaps this is what you are looking for.