I am trying to exchange any cell with a "`" in it with an asterisk "*"; if not, leave blank. Seems easy enough. Why wont this formula work?
=if(B1="`",*,,)
Thanks
I am trying to exchange any cell with a "`" in it with an asterisk "*"; if not, leave blank. Seems easy enough. Why wont this formula work?
=if(B1="`",*,,)
Thanks
Last edited by Pallando_II; 02-22-2017 at 08:28 PM.
=if(B1="`","*",,)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks