how to detect 5th character?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to tell if there is a 5th characater in a cell, instead of 4?
Thanks - Nastech
 
Hi

Try =IF(LEN(A1)>=5,"5th character","No 5th character")

Regards

Roger Govier
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

add or subtract every 5th column 2
Copy Every 5th Row 6
Lenovo recalls 80,000 5th Gen ThinkPad X1 Carbon laptops 0
5th Conditional Formatting 5
1st, 5th, 10th, 15th Anniversary dates for employees base on Hire 3
Prints only part of specificed print area 1
Return the words in every 5th row 3
Red Dead Redemption 2 is coming to PC November 5th (Steam in December) 5

Back
Top