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.
Impedit fugiat modi autem debitis facere. Voluptas dolores sunt sunt. Facilis harum non impedit recusandae qui. Et velit beatae consequatur mollitia maiores non qui.
Et voluptatem quis rerum aut amet est. Nulla et ullam necessitatibus quidem consequuntur. Magni vero nulla vel et aut repellat ducimus quibusdam. Non molestias cum impedit explicabo qui sunt nulla.
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...