| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to delete last X number of characters in a cell
using XL 2003.
Thanks!! ....Lisa |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to delete last X number of characters in a cell
If you want to get rid of the rightmost 4 characters from cell A1, for
example, use this: =LEFT(A1,LEN(A1)-4) Hope this helps. Pete On Jul 25, 4:05 pm, " wrote: using XL 2003. Thanks!! ...Lisa |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to delete last X number of characters in a cell
That did it...thanks!!
....Lisa On Jul 25, 11:08 am, Pete_UK wrote: If you want to get rid of the rightmost 4 characters from cell A1, for example, use this: =LEFT(A1,LEN(A1)-4) Hope this helps. Pete On Jul 25, 4:05 pm, " wrote: using XL 2003. Thanks!! ...Lisa- Hide quoted text - - Show quoted text - |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to delete last X number of characters in a cell
You're welcome - thanks for feeding back.
Pete On Jul 25, 4:43 pm, " wrote: That did it...thanks!! ...Lisa On Jul 25, 11:08 am, Pete_UK wrote: If you want to get rid of the rightmost 4 characters from cell A1, for example, use this: =LEFT(A1,LEN(A1)-4) Hope this helps. Pete On Jul 25, 4:05 pm, " wrote: using XL 2003. Thanks!! ...Lisa- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete first two characters in a cell... | Excel Worksheet Functions | |||
| Delete first few cell characters | Excel Discussion (Misc queries) | |||
| delete all the cell that contains more than 25 characters | Excel Discussion (Misc queries) | |||
| Delete A Word That Exceeds X Number Of Characters | Excel Worksheet Functions | |||
| can i delete the last 3 characters in each cell in a column in 1 . | Excel Discussion (Misc queries) | |||
Linear Mode
