banner_ad

Excel formula

8459 views 1 replies
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.


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
27 April 2026
Senior Accountant

Jyoti K agarwal & co

Mumbai

Others

View Details
Company
ARTICLESHIP 27 April 2026
CA Articled Assistant

GM Corporate Solutions

Noida

CA Final

View Details
Company
22 May 2026
Audit assistant

Displayandbeyond

Mumbai

CA

View Details
Company
11 May 2026
AUDIT INTERN

M/S K.K.KHANNA AND COMPANY

Noida

CA Foundation

View Details
Company
18 May 2026
MIS Executive

Primarc Pecan Retail Limited

Mumbai

B.Com

View Details
Company
19 May 2026
Article, CA & Paid Assistant Positions

Aggarwal Sarawagi and Co

New Delhi

CA

View Details
Company
ARTICLESHIP 14 May 2026
CA ARTICLE

PRAVEEN GARG & CO

Faridabad

CA Foundation

View Details
Company
ARTICLESHIP 30 April 2026
Article Assistant

J SINGH & ASSOCIATES

Ahmedabad

CA Inter

View Details