Forum Discussion
Trying to find a way to find and add text in front of found text.
I'm trying to find a way in Excel to find text and then add a character in front of found text. For example Find: Yellow Filled cell with any number and add D in front of found number. Is there anywa...
Filter the rows with Yellow filled cells and in next column =CONCATENATE("Cell"&"D") and copy this for all rows. There you have your Yellow filled entries having D in the end of number in each cell.