Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 10th 18, 12:41 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2016
Posts: 79
Default Copy/Paste problem with =Proper function

The cells in column A contain:

A Fistful of Goats
A Goat at the Opera
A goat called Wanda
A Goat Grows in Brooklyn
A Goat of their Own
a Goat runs through it
A Goat to Remember

I type =proper(a1) in B1 and the result is 'A Fistful of Goats'.

When I copy the function in B1 and paste it into B2 to B7, the result (in all of the cells) is 'A Fistful of Goats".

However, the cell references in B2 thru B7 are correct:

=PROPER(A2)
=PROPER(A3)
=PROPER(A4)
=PROPER(A5)
=PROPER(A6)
=PROPER(A7)

How can I resolve this problem?

  #2   Report Post  
Old June 10th 18, 03:20 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2015
Posts: 947
Default Copy/Paste problem with =Proper function

The cells in column A contain:

A Fistful of Goats
A Goat at the Opera
A goat called Wanda
A Goat Grows in Brooklyn
A Goat of their Own
a Goat runs through it
A Goat to Remember

I type =proper(a1) in B1 and the result is 'A Fistful of Goats'.

When I copy the function in B1 and paste it into B2 to B7, the result (in all
of the cells) is 'A Fistful of Goats".

However, the cell references in B2 thru B7 are correct:

=PROPER(A2)
=PROPER(A3)
=PROPER(A4)
=PROPER(A5)
=PROPER(A6)
=PROPER(A7)

How can I resolve this problem?


I'm getting this:

A Fistful Of Goats
A Goat At The Opera
A Goat Called Wanda
A Goat Grows In Brooklyn
A Goat Of Their Own
A Goat Runs Through It
A Goat To Remember

I did this 2 ways and got the same results;

1st way:
select B1:B7
type =proper(a1)
hit Ctrl+Enter to populate the selection with the formula

2nd way:
select C1
type =proper(a1)
hit Enter
drag down to C7

Perhaps you should save your work, quit Excel, then restart Excel and try
again. If that fails then reboot and start with a clean cache!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
  #3   Report Post  
Old June 10th 18, 05:41 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2016
Posts: 79
Default Copy/Paste problem with =Proper function

When I click F2 and press "Enter", the result in THAT cell changes to the expected (i.e., correct) result.

or when I save the spreadsheet, the results in ALL cells change to the expected (i.e., correct) results.
  #4   Report Post  
Old June 10th 18, 05:45 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,607
Default Copy/Paste problem with =Proper function

Hi,

Am Sun, 10 Jun 2018 09:41:10 -0700 (PDT) schrieb GARYWC:

When I click F2 and press "Enter", the result in THAT cell changes to the expected (i.e., correct) result.

or when I save the spreadsheet, the results in ALL cells change to the expected (i.e., correct) results.


your calculation is set to "Manuell"


Regards
Claus B.
--
Windows10
Office 2016
  #5   Report Post  
Old June 10th 18, 07:38 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2016
Posts: 79
Default Copy/Paste problem with =Proper function

Solved!

The Workbook settings was "Manual. Recalculate before saving"



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
copy and paste problem in vb Blubber Excel Discussion (Misc queries) 5 November 13th 08 05:54 PM
Copy and Paste Problem Ronald W. Roberts Excel Programming 3 July 20th 08 04:00 AM
copy paste problem? Neil22 Excel Discussion (Misc queries) 5 January 10th 06 05:32 PM
Excel cut/Paste Problem: Year changes after data is copy and paste Asif Excel Discussion (Misc queries) 2 December 9th 05 05:16 PM
Copy/Paste Problem Pete McCosh[_5_] Excel Programming 0 October 1st 03 05:14 PM


All times are GMT +1. The time now is 12:03 AM.

Powered by vBulletin® Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017