text vs picture of text

butch · Apr 9th, 2002, 01:43 AM

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?

Qroozn · Apr 9th, 2002, 01:48 AM

try paste special
and paste values only.

butch · Apr 9th, 2002, 02:15 AM

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

Qroozn · Apr 9th, 2002, 02:17 AM

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.

butch · Apr 9th, 2002, 02:40 AM

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

Chris Davison · Apr 9th, 2002, 03:01 PM

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

Jack in the UK · Apr 9th, 2002, 03:06 PM

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.

g_erhard · Apr 9th, 2002, 04:31 PM

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).

Qroozn · Apr 9th, 2002, 07:27 PM

WooHoo.
I may have even been right for once.

Apr 9th, 2002, 03:01 PM	#6
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	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 ::

Apr 9th, 2002, 03:06 PM	#7
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	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"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 9th, 2002, 01:43 AM	#1
butch New Member Join Date: Apr 2002 Posts: 3	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?

Apr 9th, 2002, 01:48 AM	#2
Qroozn Board Regular Join Date: Mar 2002 Location: Sydney/Brisbane , Australia Posts: 539	try paste special and paste values only.

Apr 9th, 2002, 02:15 AM	#3
butch New Member Join Date: Apr 2002 Posts: 3	my box had choices of paste as html paste as unicode text paste as text with no formatting i had no luck there

Apr 9th, 2002, 02:17 AM	#4
Qroozn Board Regular Join Date: Mar 2002 Location: Sydney/Brisbane , Australia Posts: 539	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.

Apr 9th, 2002, 02:40 AM	#5
butch New Member Join Date: Apr 2002 Posts: 3	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

Apr 9th, 2002, 04:31 PM	#8
g_erhard New Member Join Date: Mar 2002 Location: San Ramon CA Posts: 23	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).

Apr 9th, 2002, 07:27 PM	#9
Qroozn Board Regular Join Date: Mar 2002 Location: Sydney/Brisbane , Australia Posts: 539	WooHoo. I may have even been right for once.