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 :
- Consultation
- E-way notices2222
- Gst file not created
- Regarding 3CEB query
- Omitted E-Commerce Sales Reported in Table 14 but
- Omitted sales shown in GSTR-1 Table 14 but not in
- EWAY BILL TAKE OUT OF OTHER COMPAMY
- Penalty & late fee for late ITR filing
- Business discontinued as Government took possessio
- Which Aviation Services Can Air Ticketing Professi
Related Topics :
CAclubindia
