AgTalk Home
Search
Forums
|
Classifieds
|
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 Talk
Message format
Flat
Threaded
Nested
Schuerman Farms
Posted
12/11/2019 23:49 (#7901902 - in reply to #7900498)
Subject:
RE: Trim a column in a spreadsheet?
WC MN & Valley of the Sun, AZ
=LEFT
(A2,20
)
Will give first 20 characters. Adjust as needed. The trick would be businesses with different length names.
Or even better....
Copy the csv data and paste special, telling it to break everything with a space into its own cell.
Edited by Schuerman Farms 12/11/2019 23:50
Trim a column in a spreadsheet?
-
Chris
: 12/11/2019 07:56
RE: Trim a column in a spreadsheet?
-
Chris
: 12/11/2019 10:10
RE: Trim a column in a spreadsheet?
-
Schuerman Farms
: 12/11/2019 23:49
RE: Trim a column in a spreadsheet?
-
PrecisionNE
: 12/11/2019 10:59
RE: Trim a column in a spreadsheet?
-
Chris
: 12/11/2019 12:28
RE: Trim a column in a spreadsheet?
-
Omar
: 12/11/2019 11:07
RE: Trim a column in a spreadsheet?
-
Chris
: 12/11/2019 12:41
RE: Trim a column in a spreadsheet?
-
Omar
: 12/12/2019 07:34
RE: Trim a column in a spreadsheet?
-
Omar
: 12/12/2019 09:23
RE: Trim a column in a spreadsheet?
-
dko_scOH
: 12/11/2019 19:24
RE: Trim a column in a spreadsheet?
-
Don Smith
: 12/12/2019 10:53
RE: Trim a column in a spreadsheet?
-
chirpfarm
: 12/13/2019 08:46
Jump to forum :
Forums List
----------------------
+ Machinery Talk
+ Where Can I find?????
+ Crop Talk
+ Stock Talk
+ AgTalk Cafe
+ Kitchen Table
+ Precision Talk
+ Drone Talk
+ Computer Talk
+ Market Talk
+ Test Forum
+ FAQ & Support
Search this forum
Printer friendly version
E-mail a link to this thread
(
Delete cookies
)