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...
You can easily accomplish this in Excel by using the "Find and Replace" feature combined with a bit of formula work. First, you could use the =IF(ISNUMBER(SEARCH("Yellow", A1)), "D"&A1, A1) formula to add "D" in front of the number if the cell contains the word "Yellow." Then, you can copy and paste the result over the original data if needed. Also, if you're interested in checking Kentucky public records, like criminal or court records, you can visit https://arrestss-ky.org for more information.