Needing certain text to appear to the left of data

J

JustinImprezive

I'm hoping this is an easy one... we'll see

I am trying to have the text "Dial=9" appear without quotes to the left of
anything else input into a cell. I am going to input phone numbers to the
right of the "Dial=9", so the finished cell should look like this
"Dial=99135551234".

The tricky part is the text needs to show only is there is a phone number
input into the cell. If the cell has no other data, I would like the cell to
remain blank.

Thanks for any help you can give...

Justin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top