copy & paste and change format

S

SLB

I am copying a large amount of written data from one Excel spreadsheet and
pasting into another. The orginal information is in ALL Caps. I want to
format the pasted information to be in lower case. Help.
 
O

oldchippy

SLB said:
I am copying a large amount of written data from one Excel spreadsheet
and
pasting into another. The orginal information is in ALL Caps. I want
to
format the pasted information to be in lower case. Help.
Click to expand...
Hi,

If your pasted text is in column A, insert in B1

=LOWER(A1) , then drag this down, then copy column B, paste special >
values. Then delect column A

oldchippy :)
 
S

SLB

I'll give it a try, thanks for your help.

oldchippy said:
Hi,

If your pasted text is in column A, insert in B1

=LOWER(A1) , then drag this down, then copy column B, paste special >
values. Then delect column A

oldchippy :)
Click to expand...
 
Top