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 individual cells so when it comes throught to the layout program it is very clean.
My problem is with variable with the phone:
I have combined PHONE 1 & PHONE 2 cells to be PHONE COMBINED = 0508 xxx xxx; 09 xxx xxxx
I then combine the NAME cell with the PHONE COMBINED and add in the FAX and EMAIL (adding in Ph: Fax: and E: before respective fields.
The final cell combination is Jim Brown (NAME) Ph: 0508 xxx xxx; 09 xxx xxxx (PHONE COMBINED) Fax: 09 xxx xxxx (FAX) Email: sale@gmail.com (EMAIL)
But what I really require is that the 0508 xxx xxxx has Freephone: in front of it and then the 09 xxx xxxx has Ph: in front of it - so it would read Jim Brown (NAME) FreePhone: 0508 xxx xxx; Ph: 09 xxx xxxx (PHONE COMBINED) Fax: 09 xxx xxxx (FAX) Email: sale@gmail.com (EMAIL).
The database PHONE1 and PHONE2 can sometime be swapped around so the Freephone can be either PHONE1 or PHONE2, or neither.
I have attached a couple of screenshots, hope that helps.
Thanks.
1 Reply
- SergeiBaklanDiamond Contributor
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?