Excel formula

7569 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