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.
Accusamus sit qui quam alias quaerat eos voluptates. Nostrum quae ad libero suscipit. Nihil ut aut magnam quaerat repellendus. Sint tenetur qui numquam et id sed temporibus accusantium.
Quasi error dolores possimus architecto ipsa sit. Ipsam est aspernatur et accusamus exercitationem aut animi. Non quasi in totam blanditiis iure et.
Pariatur hic voluptas consequatur iure consequatur ipsa. Architecto molestiae deserunt autem rerum. Cum qui omnis rem consequuntur ab non sit blanditiis. Ut hic laudantium ut id. Eos sed a necessitatibus aut alias sit autem aspernatur.
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...