Hi - obviously new to this and am being tripped up by what I am sure is a simple problem.

I am setting up a business card using the client's contact details. The data is set out in a single text box with, for example, the word "Tel:" next to the telephone number - eg

Tel: +61 2 9792 5555
Fax: +61 2 9775 4444
Mob: +61 413 111 111
Email: smith@smith.com

Now while if the field with the phone number in it is left blank it doesn't appear I can't work out how to make the word "Tel:" disappear. I have tried a tried an IF function as per below:

IF (TRIM([Phone Number]) <> "", "Telephone [Phone Number]", "")

but when I export it to PSWeb it doesn't work - it appears as "Telephone [Phone Number]".

Any help would be appreciated.

Thanks.

You're almost there, [Phone Number] should not be between quotes.

IF (TRIM([Phone Number]) <> "", "Tel: " & [Phone Number], "")

Perfect - thanks for that - I knew it must have been something small!