Forum Discussion

Leanne Dean's avatar
Leanne Dean
Copper Contributor
Jul 31, 2017

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

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond 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?

     

Resources