May 02 2020 10:33 AM
I want to find cells with: TH1-1 through TH1-16 and replace with TH1-1-A through TH1-16-A. Basically keeping all characters before the -A
May 02 2020 10:54 AM - edited May 02 2020 10:56 AM
May 02 2020 01:10 PM
In addition, in Options select Match entire cell contents, if that's your case. Otherwise values as TH1-12 will be replaced on TH1-1-A2, etc.
May 02 2020 03:27 PM