Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,624
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,058
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Text to the left and right of a character Esra[_2_] Excel Worksheet Functions 4 January 28th 08 10:56 PM
Find text within cell then display text to left Jambruins Excel Discussion (Misc queries) 5 April 17th 06 10:01 PM
Formula for reminder of data needing review on dates? Scorp Excel Worksheet Functions 1 February 13th 06 07:06 AM
Newbie - needing advice on formatting webform data antfarm Excel Discussion (Misc queries) 6 July 14th 05 12:38 PM
Text to Columns from the Left Jim Excel Worksheet Functions 2 December 20th 04 09:25 PM


All times are GMT +1. The time now is 12:46 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"