Sheila has attended:
Excel Advanced course
Trimming text charatcers from cells in Excel
How could I trim say 12 characters from the right of a cell in Excel?
RE: Trimming text charatcers from cells in Excel
Hi Sheila, Thank you for your post, welcome to the forum, in your case if you wish to trim these characters from the right of cell A1 then use this formula; =RIGHT(A1, LEN(A1)-12)
to trim from the left substitute LEFT the length to trim will be the final number in this case -12, I hope that helps, best regards Pete