SanjayaGarg
New Member
- Joined
- Nov 10, 2017
- Messages
- 22
- Office Version
- 2013
- Platform
- Windows
Dear all,
I am having following data in A column :
A B C D E
Formula in B column, gives result as in C which is ok. Formula in column D is working fine if column A contains "13-00-" but if it contains any value after 13- then its not functioning. In that case I want it to return value in column C. Kindly help.
I am having following data in A column :
A B C D E
13-00-012345-000-1214 | =SUBSTITUTE(A1, "-", "") | 13000123450001214 | =IF((SEARCH("13-00-", A1)), (MID(A1, 7, 6)), C1) | 012345 |
13-59-005619-210-1001 | 13590056192101001 | #VALUE! |
Formula in B column, gives result as in C which is ok. Formula in column D is working fine if column A contains "13-00-" but if it contains any value after 13- then its not functioning. In that case I want it to return value in column C. Kindly help.