| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create a list of text from a single cell on several worksheets? | Excel Discussion (Misc queries) | |||
| linking a cell containing text to another cell containing text / data | Excel Discussion (Misc queries) | |||
| Text not continuing to wrap for large block of text in Excel cell | Charts and Charting in Excel | |||
| How can I make an excel cell equal to the value of a frame object text box | Excel Worksheet Functions | |||
| Help inserting a Cell Value in a Text Cell | Excel Worksheet Functions | |||
Linear Mode
