copy & paste and change format
 

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.

copy & paste and change format
 

SLB Wrote:
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.
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 :)


--
oldchippy
------------------------------------------------------------------------
oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907
View this thread: http://www.excelforum.com/showthread...hreadid=569601

copy & paste and change format
 

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

"oldchippy" wrote:


SLB Wrote:
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.
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 :)


--
oldchippy
------------------------------------------------------------------------
oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907
View this thread: http://www.excelforum.com/showthread...hreadid=569601