to replace only the last text/chracter in a cell
R roadkill Mar 1, 2007 #2 I'm not clear what you're asking but let me take a shot at an answer. If you have text in A2 and you want the last character to be replaced by what's in B2 and the result put in C2, you could put the following in C2: =left(A2,len(A2)-1) & B2 Will
I'm not clear what you're asking but let me take a shot at an answer. If you have text in A2 and you want the last character to be replaced by what's in B2 and the result put in C2, you could put the following in C2: =left(A2,len(A2)-1) & B2 Will
