Hi all,
I am trying to format a column so that I can identify when a cell contains lowercase letters and then I can change each cell to uppercase. The problem is that the cells change length and format down the list so I cannot use the =EXACT formula.
Example:
<tbody>
</tbody>
Thanks team,
Milos
I am trying to format a column so that I can identify when a cell contains lowercase letters and then I can change each cell to uppercase. The problem is that the cells change length and format down the list so I cannot use the =EXACT formula.
Example:
Topo Code | Topo Code | |||
1 | AA123 | 1 | AA123 | |
2 | p456 | With conditional format applied | 2 | p456 |
3 | Ab789 | ==============> | 3 | Ab789 |
4 | FF89 | 4 | FF89 | |
5 | Gg09 | 5 | Gg09 |
<tbody>
</tbody>
Thanks team,
Milos