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 :
- Itr 4 problem
- Capital Gains Mismatch Due to Sale Agreement in FY
- REGARDING NRO INVESTMENT IN SHARES OF DOMESTIC COM
- DTAA benefits
- SUPPLEMENTARY AGREEMENT FOR ADDING A PARTER IN TN
- Part availmement of ITC in case of rejection of su
- Due date for itr 5 no audit with loss for fy 25 26
- Capital Gains Mismatch AIS
- Inward E-way bill from Tally Prime 7.1
- Query regarding exemption under Section 10(10AA) &
Related Topics :
CAclubindia
