Jul 09 2019 03:35 AM - edited Jul 09 2019 03:36 AM
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.
Jul 09 2019 04:20 AM
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
Jul 09 2019 04:31 AM