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

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

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

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

"KKay" wrote:

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

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

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

remove nospam for email addy!



"KKay" wrote:

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

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

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

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

Many Thanks that was very helpful exactly what i needed.

"Toppers" wrote:

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

"KKay" wrote:

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

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

Thanks PAul used the RIGHT formula and worked out.

"paul" wrote:

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

remove nospam for email addy!



"KKay" wrote:

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

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

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

"Franz Verga" wrote:

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