Excel on the iPad Pro

Copper Contributor

Guys

 

Really hoping someone can help. I use Excel on the iPad Pro and I’m trying to use the find and replace feature. I select a column but i am struggling with replacing Blank spaces with 0. Unlike excel on a mac where you just leave the ‘find’ box blank, doing the same on the iPad Pro greys out the replace button. Any suggestions or work arounds?

 

Thanks 

0 Replies