Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Needing certain text to appear to the left of data
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Needing certain text to appear to the left of data
One way:
Format/Cells/Number/Custom "Dial=9"0;;; In article , JustinImprezive wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Needing certain text to appear to the left of data
Format Cells... Number Custom "Dial=9"General
-- Gary''s Student - gsnu200820 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text to the left and right of a character | Excel Worksheet Functions | |||
Find text within cell then display text to left | Excel Discussion (Misc queries) | |||
Formula for reminder of data needing review on dates? | Excel Worksheet Functions | |||
Newbie - needing advice on formatting webform data | Excel Discussion (Misc queries) | |||
Text to Columns from the Left | Excel Worksheet Functions |