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
- GST on business receipts pre -registration
- A Restaurant registered under the Composition Sche
- GST RATE OF OUT DOOR CATERING
- Non resident taxation & income tax in India
- GST Rate for oral Hygiene Combo Pack
- GST registration - Address error
- TDS on property pu
- Import of goods IMS action related
- Incometax Survey - Updated Return Filing after the
- TCS under 206C(1F)
Related Threads
CAclubindia
