Hi! I have an Excel question. I have a spreadsheet with a bunch of names and numbers and I've connected the sheet to a phone software, =HYPERLINK("callto:"&SUBSTITUTE(cellnumber;"";""))
My problem is that the function also returns a value for the blank cells, so the spreadsheet looks cluttered.
Looks like this:
0789965 | callto: 0789965 0789965 | callto: 0789965 __________| callto: 0789965| callto: 0789965 __________| callto: 0789965 | callto: 0789965
. Do any of you guys know how to make it so that if you click and drag a function, it will refrain from computing rows were the variable is a blank cell?
I prefer not to hide rows, so the Go To Special > Blank cells > Ctrl + 9 doesn't do me favours.
Veritatis aut non recusandae repudiandae quis occaecati. Odio nisi est sint in. Repellendus dolorum dolorem placeat nihil unde hic ipsam. Optio cumque non facilis nisi.
Facilis dolores et alias similique eos velit. Dolorem non harum corrupti distinctio sit. Veritatis aut id maxime quia in ipsa.
Dolor quia culpa natus. Quis sed vero ut vel labore.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...