How to make this formula not case sensitive
Difference between Substitute and Replace Function
excel - Replace part of text in a cell case sensitive - Stack Overflow
How to use Excel VBA replace function with case sensitivity? - Stack Overflow
I have this.
=IF(COUNTIF($A2,"* *"),CONCATENATE(MID((IF(ISERR(FIND(" ",$A2)),"",LEFT($A2,FIND(" ",$A2)-1))),1,(30-LEN($T2))/2)&MID(TRIM(RIGHT(SUBSTITUTE($A2," ",REPT(" ",100)),100)),1,(30-LEN($T2))/2)),CONCATENATE(LEFT($A2,(30-LEN($T2)))))
Basically it looks for spaces IF(COUNTIF($A2,"* *")
if there is no spaces it just takes from cell CONCATENATE(LEFT($A2,(30-LEN($T2)))))
If there are spaces CONCATENATE(MID((IF(ISERR(FIND(" ",$A2)),"",LEFT($A2,FIND(" ",$A2)-1))),1,(30-LEN($T2))/2)&MID(TRIM(RIGHT(SUBSTITUTE($A2," ",REPT(" ",100)),100)),1,(30-LEN($T2))/2))
This takes from the first word MID((IF(ISERR(FIND(" ",$A2)),"",LEFT($A2,FIND(" ",$A2)-1))),1,(30-LEN($T2))/2)
This takes from the last word MID(TRIM(RIGHT(SUBSTITUTE($A2," ",REPT(" ",100)),100)),1,(30-LEN($T2))/2))
I put it into action today and realized that if it has a space it dose not work if the words in the cell are all Capital Letters.
Any suggestions to make it work for Capitals