Needing certain text to appear to the left of data

  • Thread starter Thread starter JustinImprezive
  • Start date Start date
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
 
Back
Top