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

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.

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

hi

=left(a2,155)

hth
regards from Brazil
Marcelo

"zahara" escreveu:

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.

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

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.

"zahara" wrote:

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.