hsandeep
Well-known Member
- Joined
- Dec 6, 2008
- Messages
- 1,215
- Office Version
- 2010
- Platform
- Windows
- Mobile
C5=MAngO123-99 Tomato D5=ITALIAN Forest Trees E5=26
In F5 I want first 26 (E5) digits after removing spaces from C5 & D5 & suffixing D5 with C5 & in UPPER CASE.
Answer:
MANGO123-99TOMATOITALIANFO.
How to accomplish?
In F5 I want first 26 (E5) digits after removing spaces from C5 & D5 & suffixing D5 with C5 & in UPPER CASE.
Answer:
MANGO123-99TOMATOITALIANFO.
How to accomplish?