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?

 

[Shweta]

Try this

=RIGHT(C1,D1) & drag it down.

 

[inspectoRQ]

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?

=left(find("-")+1,10) 10 is the length of number. if your number`s length is longer, you can write there 100 or more

 

[inspectoRQ]

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?

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

 

[Haldoug]

Shweta is correct with =right(c5,d5), but since you have 9999 lines, you may want to do the right bottom of the cell double click trick instead of dragging.

 

[inspectoRQ]

Shweta is correct with =right(c5,d5), but since you have 9999 lines, you may want to do the right bottom of the cell double click trick instead of dragging.

it is right if length of number constant. but if they are differen for ex. in of them lenght of number 6 and in another 9. there will be wrong result

 

[hsandeep]

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

This didnot WORK.

 

[hsandeep]

=left(find("-")+1,10) 10 is the length of number. if your number`s length is longer, you can write there 100 or more

Where to write this formula? There is no C5 & D5!!

 

[Peter_SSs]

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?

Excel Workbook
	C	D	E
5	Peter-0085964	6	085964
6	Peter-0085964	9	r-0085964
Last Characters

 

[inspectoRQ]

Where to write this formula? There is no C5 & D5!!

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