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 Rule 14A for Export of Service with Hypothetic
- GST ON QUERY
- Initimation on AIS
- GST on sponsorship from foreign body corporate
- Revised Income tax return karna padega kya
- Registration as deductor on traces site
- Rental Income from a Joint Holding property
- Itr 4 return filing question
- Whether GST applicable on Hardship Compensation pa
- ITC cannot be denied to Bona Fide Buyers for Suppl
Related Threads
CAclubindia
