Extract last few digits from a cell

[hsandeep]

I have value in column C5:C9999. It contains alphanumeric along with special characters.
Column D5:D9999 contains numerical +ve integer.
How to extract last D column digits from column C in column E5:E9999?

Ex:
C5=Peter-0085964 D5=6
E5 should be 085964

C6=Peter-0085964 D6=9
E6=r-0085964

How to accomplish?

 

[Trebor76]

This didnot WORK.

As commas, not semicolons are needed to identify different arguments of a formula, inspectoRQ's formula therefore won't work as posted.

 

[hsandeep]

hsandeep

You seem to have made no comment about the suggestions made by Shweta and Haldoug. Have you tried that method? In what way did it not work?

Aren't these the results you were expecting as described in your first post?

Last Characters

	C	D	E
Peter-0085964
Peter-0085964

<COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 119px"><COL style="WIDTH: 39px"><COL style="WIDTH: 91px"></COLGROUP><TBODY>
[TD="bgcolor: #cacaca, align: center"]5[/TD]

[TD="align: center"]6[/TD]
[TD="align: center"]085964[/TD]

[TD="bgcolor: #cacaca, align: center"]6[/TD]

[TD="align: center"]9[/TD]
[TD="align: center"]r-0085964[/TD]

</TBODY>

Spreadsheet Formulas

Cell Formula E5 =RIGHT(C5,D5) E6 =RIGHT(C6,D6) <TBODY> </TBODY>

<TBODY>
</TBODY>

Excel tables to the web >> Excel Jeanie HTML 4

Shweta's formula WORKS.

 

[hsandeep]

write this formula =MID(c5;FIND("-";c5)+1;10)

Where to punch this formula? because there is no D column....

 

[Peter_SSs]

Where to punch this formula? because there is no D column....

I don't think that formula is aimed at your solution. It extracts what is the the right of the "-", not the number of characters shown in column D as your original post requested. If Shweta's formula works, which I believe it does, then just use that.

 

[inspectoRQ]

I don't think that formula is aimed at your solution. It extracts what is the the right of the "-", not the number of characters shown in column D as your original post requested. If Shweta's formula works, which I believe it does, then just use that.

that formula find "-" and get the character righside, =right formula wont work if length of characters are different at rightside

 

[Peter_SSs]

that formula find "-" and get the character righside, ...

Yes, but the OP doesn't just want the characters to the right of the "-", they want the number of characters specified in column D. Look especially at the expected result for the second example that was given.

Ex:
C5=Peter-0085964 D5=6
E5 should be 085964

C6=Peter-0085964 D6=9
E6=r-0085964
How to accomplish?

 

[Worf]

As commas, not semicolons are needed to identify different arguments of a formula, inspectoRQ's formula therefore won't work as posted.

This depends on what country you are at. The Brazilian version of Excel uses semicolons as separators for formula arguments...

 

[Trebor76]

This depends on what country you are at. The Brazilian version of Excel uses semicolons as separators for formula arguments

Thanks Worf - learnt something new today