copy & paste and change format

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

[oldchippy]

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

[SLB]

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