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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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...
 
depending exactly how many characters you have and want you should be using
MID or even Right
 
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...
Click to expand...


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
 
Back
Top