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

Z

zahara

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.
 
K

kassie

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to create an IF function 1
Make the charecters in a cell to equal a certain quanity 2
Excel does not accept text format! 0
Conditional Formatting ignoring cells with a format already 2
Adding text columns 2
Merging from an Excel file with graphics 1
vlookup based on a different cell 3
How should I do this (function or Visual basic) 5

Top