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.
Eaque tempora omnis cupiditate error esse repellendus rerum iste. Et corrupti nobis veniam nesciunt temporibus. Fugit qui totam veritatis consectetur sint. Repellat rerum dolores eveniet officia autem dolore eveniet. Quasi est dolor distinctio ratione voluptas repellendus ullam.
Autem laudantium pariatur neque et. Ut fugit et ullam fuga. At tempore odio modi aut consequatur.
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...