How can I pick up characters after the first 4 in Excel cell

[Guest]

I have a cell containing digits and alpha numeric characters. I want to pick
up just the alpha numeric characters which are all after the first four
characters in the cell.

Is there formula I can use without having to split out the first 4
characters with the formula LEFT...

 

[Guest]

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

 

[Guest]

depending exactly how many characters you have and want you should be using
MID or even Right

 

[Franz Verga]

Nel post *KKay* ha scritto:

I have a cell containing digits and alpha numeric characters. I want
to pick up just the alpha numeric characters which are all after the
first four characters in the cell.

Is there formula I can use without having to split out the first 4
characters with the formula LEFT...

I think you can use RIGHT function:

=RIGHT(B6,LEN(B6)-4)

where B6 is the cell with your alphanumeric characters.

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

 

[Guest]

Many Thanks that was very helpful exactly what i needed.

 

[Guest]

Thanks PAul used the RIGHT formula and worked out.

 

[Guest]

Thanks Franz, that was very helpful, exactly what I needed.