CODEWITHSUNDEEP
excel
Trey Copeland
Trey Copeland

Reputation: 3527

How to check for ending period in Excel?

What formula can I use to check if there is a period on the end of my cell. If there isn't add one. Thanks!

enter image description here

Upvotes: 1

Views: 3389

Answers (1)

BruceWayne
BruceWayne

Reputation: 23283

Place this formula next to your cells you want to check (I used A1 as example).

=If(A1<>"",If(Right(A1,1)=".",A1,A1&"."),"")

If A1 is not empty (A1<>"") Then: If the right most digit (Right(A1,1)) is a period =".", then return A1. If not a period, then add a period to the text A1 & ".".

otherwise, if the cell is empty, just leave the space empty (,"")).

Upvotes: 2

Related Questions