Looking for an excel formula that lower cases all letters up to ;

[easycreates]

Hello,

I am looking for an excel formula that lower cases all letters up to ;

For example, biGtReeL@BiGtree.com;FgA123456789

In this case, all the letters up to ";" should be lower cased. Similar to =REPLACE(A1,1,1,LOWER(LEFT(A1)))

Thanks.

[#2]

Hi @easycreates 

This formula should work for you.

=LOWER(LEFT(A1,MAX((EXACT(MID(A1,ROW(INDIRECT("A1:A"&LEN(A1))),1),";"))*ROW(INDIRECT("A1:A"&LEN(A1))))))&MID(A1,MAX((EXACT(MID(A1,ROW(INDIRECT("A1:A"&LEN(A1))),1),";"))*ROW(INDIRECT("A1:A"&LEN(A1))))+1,LEN(A1))

This is and array formula and needs to be entered with Shift, Control Enter

[#3]

@easycreates 

As variant

=SUBSTITUTE(A1,LEFT(A1,SEARCH(";",A1)),LOWER(LEFT(A1,SEARCH(";",A1))))