| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
trim
Heloo everyone,
I am looking for a simple formula: in a column of numerical values such as 50405, how would i get rid of the last two numbers, i.e from 50405 to 504. Thank you, Geza |
|
#2
|
|||
|
|||
|
Try this formula
=--LEFT(A1,LEN(A1)-2) -- Regards Ron de Bruin http://www.rondebruin.nl "geza" wrote in message ... Heloo everyone, I am looking for a simple formula: in a column of numerical values such as 50405, how would i get rid of the last two numbers, i.e from 50405 to 504. Thank you, Geza |
|
#3
|
|||
|
|||
|
Thank you Ron.
"Ron de Bruin" wrote: Try this formula =--LEFT(A1,LEN(A1)-2) -- Regards Ron de Bruin http://www.rondebruin.nl "geza" wrote in message ... Heloo everyone, I am looking for a simple formula: in a column of numerical values such as 50405, how would i get rid of the last two numbers, i.e from 50405 to 504. Thank you, Geza |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trim data in charts | Charts and Charting in Excel | |||
| Using trim feature | Excel Worksheet Functions | |||
| Excel TRIM() can't handle in pasted HTML | Excel Discussion (Misc queries) | |||
| Trim function doesn't clean out ASCII Code 160 (Space) | Excel Worksheet Functions | |||
| How to use TRIM function | Excel Worksheet Functions | |||
Linear Mode
