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 Threads
- UNCLAIMED TDS REFUND QUERY
- Rcm payable which head
- Query of GST
- Long Term Capitalgains on sale of residential prop
- How Salaried Individuals Can Reduce Capital Gains
- NSTPI registration
- GST PAID IN DELHI
- How to Trade Forex in India?
- TDS - requirement of TDS by individual under presu
- Normal Register in GST in delhi in gujarat no rece
Related Threads
CAclubindia
