Find a closing bracket in a cell

[krishpraj]

Hi,

I'm looking for hopefully a simple formula that looks to see if A1 has a closing bracket at the END of the cell. The end of the cell is important here.

Thanks in advance.

[Glenn Kennedy]

Hi there. Try this (assumes data start in A1).

=IFERROR(IF(FIND(")",A1)=LEN(A1),"At End","Not at End"),"")

[Glenn Kennedy]

Can there be more than one closing bracket in your cells??

[krishpraj]

Yes, there can.

[Glenn Kennedy]

Dohhh! I was making life more complicated than needed.

=IF(RIGHT(A1,1)=")","At end","Not at end")

[krishpraj]

Ah yes thanks, I knew there was an easy way too. But couldn't think of one.

Appreciated

[Glenn Kennedy]

Glad to have helped! If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.