text vs picture of text
Eliminate Pivot Table Annoyances
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 9 of 9

Thread: text vs picture of text

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    i need excel to color a cell when i type in a specific character (in this
    case the letter 'W' is conditioned to shade the cell 'green'. This is used
    for graded wins(W) and losses (L) in baseball) with the "L" losses to be
    colored in blue.

    i have done that, under conditional formatting. But when i copy and paste
    the same 'logs' from a website and paste them into Excel (to save time for
    adding many games to the logs instead of typing each result of "W" and "L ")
    for the shading to take place , of course the entry is not text but a
    picture of text ( a bitmap .bmp i guess) and Excel will not shade (or
    pattern ) the cell
    How (or can) i paste the results from a webpage and have Excel format the
    characters as if i were typing in text from the keyboard?


  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Sydney/Brisbane , Australia
    Posts
    538
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    try paste special
    and paste values only.

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    my box had choices of
    paste as html
    paste as unicode text
    paste as text with no formatting
    i had no luck there

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Location
    Sydney/Brisbane , Australia
    Posts
    538
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    ok. try pasting as text in other cells.
    then copy and paste it as special--text only. int he correct cells

    see if that works.

  5. #5
    New Member
    Join Date
    Apr 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    i can tell you have me on the right track......i need to tinker a bit moreto get the results i need
    thanks alot ...3 other boards got blank stares at this question for days
    CHEERS

  6. #6
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Butch,

    when I copy from this board (ie formulae) I use paste special unicode text...... otherwise, as you say, it comes with the colours and formatting
    :: Pharma Z - Family drugstore ::

  7. #7
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi

    Sorry guys think this

    copy... ermm what exactly are you copying.. text values or something else..

    so then your pasting what you copy....

    so maybe you copying more than you think...poss you taking something with you??? Yes ... No???

    dhtml or pearl whatever Bill runs this board on is not just text so all carries over.. format intacted... so i beleive.

    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  8. #8
    New Member
    Join Date
    Mar 2002
    Location
    San Ramon CA
    Posts
    23
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    When you copy from many Windows programs (especially Microsoft apps) the clipboard maintains details about the type of document you copied from, and then attempts to replicate that when you paste to an app that'll support it (like Excel, Word, or Outlook).

    To get around this, try Paste Special, then use either Text or Unicode. Text works great for me, but would possibly hose up what you're copying if it includes extended characters (character values > 128).

  9. #9
    Board Regular
    Join Date
    Mar 2002
    Location
    Sydney/Brisbane , Australia
    Posts
    538
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      

    WooHoo.
    I may have even been right for once.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com