A amag Dec 16, 2005 #1 I have a list in which the last letter is x e.g DDLX, BBLX, XCVFX. I want the final list to look like DDL, BBL, XCVF. TIA/Amag
I have a list in which the last letter is x e.g DDLX, BBLX, XCVFX. I want the final list to look like DDL, BBL, XCVF. TIA/Amag
S Stephen Dec 16, 2005 #2 amag said: I have a list in which the last letter is x e.g DDLX, BBLX, XCVFX. I want the final list to look like DDL, BBL, XCVF. TIA/Amag Click to expand... For a list in column A starting at A1, put this formula in B1 =LEFT(A1,LEN(A1)-1) and copy down as far as necessary. If you want, you can then copy column B and use Edit > Paste Special > Values to paste the results, allowing the original list to be deleted.
amag said: I have a list in which the last letter is x e.g DDLX, BBLX, XCVFX. I want the final list to look like DDL, BBL, XCVF. TIA/Amag Click to expand... For a list in column A starting at A1, put this formula in B1 =LEFT(A1,LEN(A1)-1) and copy down as far as necessary. If you want, you can then copy column B and use Edit > Paste Special > Values to paste the results, allowing the original list to be deleted.
