| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to delete first three characters in all rows of a field
Dear Sir,
I am working in excel 2000 and want to use functions for deleting first three characters in all rows of a field by using functions. Regards Arora SK |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to delete first three characters in all rows of a field
=RIGHT(A1,LEN(A1)-3)
-- David Biddulph wrote in message ... Dear Sir, I am working in excel 2000 and want to use functions for deleting first three characters in all rows of a field by using functions. Regards Arora SK |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to delete first three characters in all rows of a field
Dear Sir,
Thank you very much for the prompt reply. It worked wonderfully well ! Regards, Arora SK "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... =RIGHT(A1,LEN(A1)-3) -- David Biddulph wrote in message ... Dear Sir, I am working in excel 2000 and want to use functions for deleting first three characters in all rows of a field by using functions. Regards Arora SK |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text Field in a cell changes characters | Excel Discussion (Misc queries) | |||
| Looking for alpha characters in a field | Excel Worksheet Functions | |||
| How to display a numeric field showing all 5 characters. | Excel Worksheet Functions | |||
| Removing characters from datetime field | Excel Discussion (Misc queries) | |||
| How do I remove the 1st 4 characters of a field in Excel? | Excel Worksheet Functions | |||
![David Biddulph[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
