Add character to the end of a string

[tad_excel_74]

What formula do I use to add a character to the end of a cell if that character is not already there?

Example: there are multiple rows... some end in "NC" and some end in "N". I'm using the quotation marks to designate that the cells end in the letters. The quotation marks are not in the cells. The cells are of varying lengths. If a cell ends in "NC", then nothing needs to be done. If a cell ends in "N", how do you add a "C" to it to make it "NC"?

 

[jtakw]

Hi,

Does this help:

Book1
	A	B
1	abcNC	abcNC
2	DEFghN	DEFghNC
3	xyzqwertyNC	xyzqwertyNC
4	dfg N	dfg NC
5	klrlmo NC	klrlmo NC
6	abc def ghi jkl N	abc def ghi jkl NC
Sheet691

Cell Formulas
Range	Formula
B1	=SUBSTITUTE(A1,IF(RIGHT(A1)="N","N",""),"NC")

 

[AlphaFrog]

Try something like this...

=IF(A1="","",IF(RIGHT(A1,2)="NC",A1,A1&"C"))

 

[tad_excel_74]

That worked!

Thank you

 

[Rick Rothstein]

Example: there are multiple rows... some end in "NC" and some end in "N".

Do any of the cells end in anything else besides "N" or "NC"?

Could any of the cells within the data area be blank?