Skip to main content
Support is Offline
Today is our off day. We are taking some rest and will come back stronger tomorrow
Official support hours
Monday To Friday
From 09:00 To 17:30
  Sunday, 03 December 2023
  0 Replies
  1.1K Visits
0
Votes
Undo
I have an Excel document which contains of several text lines (column A has the line number, column B is the text line)
I want to know which line (in column B) have more than 2 uppercase characters in a row, starting on each line at position 8

My name: Marianne (this line doesn't validate)
My name; MARIANNE (this line validates)

Each line which validates should be marked in column C.

I couldn't find to do this. Can anyone help me?

Best regards,
Marianne
There are no replies made for this post yet.