Excel help

%3CLINGO-SUB%20id%3D%22lingo-sub-1355154%22%20slang%3D%22en-US%22%3EExcel%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1355154%22%20slang%3D%22en-US%22%3E%3CP%3E%3CFONT%3EI%20want%20to%20find%20cells%20with%3A%20TH1-1%20through%20TH1-16%20and%20replace%20with%20TH1-1-A%20through%20TH1-16-A.%26nbsp%3B%20Basically%20keeping%20all%20characters%20before%20the%20-A%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1355154%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1355180%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1355180%22%20slang%3D%22en-US%22%3ESelect%20the%20column%20that%20contains%20what%20you%20want%20to%20find%20and%20replace%20using%20CTRL%2BSHIFT%20%2BDown%20Arrow%20key%3CBR%20%2F%3E%3CBR%20%2F%3EHit%20CTRL%20%2B%20H%20on%20your%20keyboard%3CBR%20%2F%3EIn%20the%20Find%20what%3A%20TH1-1%3CBR%20%2F%3EIn%20the%20Replace%20with%3A%20TH1-1-A%3CBR%20%2F%3E%3CBR%20%2F%3EClick%20Replace%20All%20%3CBR%20%2F%3E%3CBR%20%2F%3EThat's%20all..%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1355348%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1355348%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F645332%22%20target%3D%22_blank%22%3E%40loneracer%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20addition%2C%20in%20Options%20select%20%3CEM%3EMatch%20entire%20cell%20contents%3C%2FEM%3E%2C%20if%20that's%20your%20case.%20Otherwise%20values%20as%20TH1-12%20will%20be%20replaced%20on%20TH1-1-A2%2C%20etc.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1355474%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1355474%22%20slang%3D%22en-US%22%3EIs%20this%20a%20case%20of%20adding%20%22-A%22%20at%20the%20end%20of%20each%20item%3F%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20so%2C%20you%20can%20use%20TEXTJOIN%20or%20CONCAT%20unless%20there%20are%20other%20items%20in%20the%20column%20different%20from%20TH1-1%20to%20TH1-16.%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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

3 Replies
Highlighted
Select the column that contains what you want to find and replace using CTRL+SHIFT +Down Arrow key

Hit CTRL + H on your keyboard
In the Find what: TH1-1
In the Replace with: TH1-1-A

Click Replace All

That's all..
Highlighted

@loneracer 

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.

Highlighted
Is this a case of adding "-A" at the end of each item?

If so, you can use TEXTJOIN or CONCAT unless there are other items in the column different from TH1-1 to TH1-16.