Left

[ExcelRoy]

Hi,

How could I remove the first 2 characters to a cell

I was thinking LEFT but not sure

Thanks

 

[63falcondude]

If you want to remove the first 2 characters and leave the rest, try =RIGHT(A1,LEN(A1)-2)

If you only want the first 2 characters, try =LEFT(A1,2)

 

[AkaTrouble]

either right or mid

i would use right

=RIGHT(A1,LEN(A1)-2)

 

[AkaTrouble]

Try =RIGHT(A1,LEN(A1)-2)

Snap lol

 

[ExcelRoy]

That's Awesome, thanks for your time

 

[Aladin Akyurek]

Hi,

How could I remove the first 2 characters to a cell

I was thinking LEFT but not sure

Thanks

ADELANTE

would become what?

 

[63falcondude]

Snap lol

 

[63falcondude]

That's Awesome, thanks for your time

Glad to help!

 

[ExcelRoy]

Hi All,

Just thinking one step further,

If the user sometimes has the first 2 characters and sometimes not is there a way to remove the 2 as per above, but if it is just numbers to ignore the first 2 removed

ie

Entered as AA12345, but next day entered as 12345

I would ideally like the AA removed but 12345 left as it is

Thanks

 

[63falcondude]

Hi All,

Just thinking one step further,

If the user sometimes has the first 2 characters and sometimes not is there a way to remove the 2 as per above, but if it is just numbers to ignore the first 2 removed

ie

Entered as AA12345, but next day entered as 12345

I would ideally like the AA removed but 12345 left as it is

Thanks

Possibly

=IF(ISNUMBER(A1),A1,RIGHT(A1,LEN(A1)-2))

or

=IF(ISNUMBER(A1),A1,RIGHT(A1,LEN(A1)-2)+0) if you want to convert it from text to a number