Forum Discussion
Replacing a variable phone number with a prefix, each phone record can be different
Hi there I am not moving forward and would like some help with doing this in excel rather than in final layout program. I am working with a directory, I have managed to combine a lot of the data in ...
Hi Leanne,
Sorry, didn't catch. So, if your <phone1> is always free phone and <phone2> is always not free, you use something like
= ... & "Freephone: " & <phone1> & " Ph: " & <phone2> & ...
Your problem is to check if phone cell is empty or not plus to check if given phone number is for free line or not; or what?