Forum Discussion
K P
Oct 25, 2017Copper Contributor
Array Formula not working in Office 365 (Mac)
Hi, Does anyone know if there is a way to split a cell by Capital letters? For example, turning IceCream into Ice Cream (ie. Ice and Cream in different cells). I have attempted this, but I c...
SergeiBaklan
Oct 25, 2017Diamond Contributor
By the way, shorter version of second formula is
=SUBSTITUTE(A1,B1,"")