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
Hi,
Both formulas work (second not array one), please see attached. What kind of error do you have?