ExcelBanter - how can I eliminate the first 3 characters from a cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how can I eliminate the first 3 characters from a cell (https://www.excelbanter.com/excel-worksheet-functions/47672-how-can-i-eliminate-first-3-characters-cell.html)

brantty

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.

David Billigmeier

=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.

brantty

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.

Gord Dibben

=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.

All times are GMT +1. The time now is 07:51 AM.