AgTalk Home
AgTalk Home
Search Forums | Classifieds (23) | Skins | Language
You are logged in as a guest. ( logon | register )

Trim a column in a spreadsheet?
View previous thread :: View next thread
   Forums List -> Computer TalkMessage format
 
Chris
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)



Edited by Chris 12/11/2019 10:11
Top of the page Bottom of the page


Jump to forum :
Search this forum
Printer friendly version
E-mail a link to this thread

(Delete cookies)