hsandeep
Well-known Member
- Joined
- Dec 6, 2008
- Messages
- 1,226
- Office Version
- 2010
- Platform
- Windows
- Mobile
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?
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?