Posted 12/11/2019 10:10 (#7900498 - in reply to #7900235) Subject: RE: Trim a column in a spreadsheet?
East central Iowa
it's not elegant but I accomplished sort of what I want
I create a column with this formula =LEN(A2) that gives me the number of characters in the Description cell then, in the column adjacent to it I place this =LEFT(A2,LEN(A2) * 5)