View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
zahara zahara is offline
external usenet poster
 
Posts: 1
Default 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.