Menu
Excel formula
Excel formula req for Pan number in cell which contains 4th letter P =person and if it contains C = company
Replies (1)
Use formula MID(text,start_num,num_chars)
e.g.
B2 is the cell, 4 is the starting position, 1 is the no. of character to return from fourth position.
Recent Topics :
- LTCG: Home Loan Principal Repayment?
- Ims action relationship query
- GIFT REGARDING
- TDS on salary to non resident managing director
- Ewaybill and Transport documents (Lorry receipt)
- LTCG on sale of Builder Buyer Agreement
- Rule 13(2)(h) and valuation of CCDs
- Leave encashment, New labour code, Management cadr
- GST clarification needed:
- TDS processed with short deduction default
Related Topics :
CAclubindia
