| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how can I eliminate the first 3 characters from a cell
I have a cell (A2) that has a code (AAA123456B). I need a formula that will
eliminate the first 3 charatcers from this code and post the remaining characters in a new cell. Please help. |
|
#2
|
|||
|
|||
|
=RIGHT(A2,LEN(A2)-3)
-- Regards, Dave "brantty" wrote: I have a cell (A2) that has a code (AAA123456B). I need a formula that will eliminate the first 3 charatcers from this code and post the remaining characters in a new cell. Please help. |
|
#3
|
|||
|
|||
|
that worked. thanks David
"David Billigmeier" wrote: =RIGHT(A2,LEN(A2)-3) -- Regards, Dave "brantty" wrote: I have a cell (A2) that has a code (AAA123456B). I need a formula that will eliminate the first 3 charatcers from this code and post the remaining characters in a new cell. Please help. |
|
#4
|
|||
|
|||
|
=MID(A2,4,255)
Gord Dibben Excel MVP On Wed, 28 Sep 2005 13:25:03 -0700, "brantty" wrote: I have a cell (A2) that has a code (AAA123456B). I need a formula that will eliminate the first 3 charatcers from this code and post the remaining characters in a new cell. Please help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Max number of characters in a cell | Excel Discussion (Misc queries) | |||
| Exporting to CSV file with Chinese Characters in Spreadsheet | Excel Discussion (Misc queries) | |||
| Problem with counting characters in a cell | Excel Worksheet Functions | |||
| Deleting Blank Characters in a Cell | Excel Discussion (Misc queries) | |||
| Deleting 3 Text characters from the right | Excel Worksheet Functions | |||
Linear Mode
