how do i truncate text-- create cell with only 125 charecters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a spreadsheet to import into a database.

some cells have over 125 charecters for a field where the database only has
125.

i'd like to create a new column in the spreadsheet where each cell has the
first 125 charecters of the original cell.

how do i do this? thanks.
 
If you have the string in say A1, then in B1 enter =LEFT(A1). If you want to
do several rows, copy this down as far as necessary.
 
Back
Top