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.
Et libero et quidem est. Quam aspernatur unde mollitia neque cumque minima.
Accusamus enim dolores aut exercitationem sed porro tempore in. Commodi quas nulla voluptatum est aperiam. Omnis quaerat fugit reprehenderit amet magni voluptate sapiente. Labore impedit ut libero facilis.
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...