| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
| Copy & paste conditional format | New Users to Excel | |||
| Conditional formatting -- copy paste special won't change referenc | Excel Discussion (Misc queries) | |||
| Macro to find, copy, and paste until value change | Excel Worksheet Functions | |||
| change from copy & paste task pane (yuk) to c&p little box | Excel Discussion (Misc queries) | |||
Linear Mode
