Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Copying formulas

Status
Not open for further replies.
maytwo

maytwo

IS-IT--Management
Oct 6, 2010
9
US
I am trying to copy a formula and the column I am trying to match has a space between the name "Colorado Springs" when I try to paste the formula - it does not recognise the name and thus does not copy the formula.....
 
Sort by date Sort by votes


Hi,

Please post your FORMULA and all related values.

Skip,
[sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
Upvote 0 Downvote
Try using an underscore or single quotes around the name.

Best,
Blue Horizon [2thumbsup]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

E
  • Locked
  • Question
Copying spreadsheet for posting
Replies
2
Views
232
combo
combo
Damnitalldaddy
  • Locked
  • Question
excel formulas
Replies
1
Views
86
mintjulep
M
bhujanga
  • Locked
  • Question
Issue #1: Copying Charts without bringin source sheet reference
Replies
1
Views
49
SkipVought
S
kjv1611
  • Locked
  • Question
Excel Formulas: Links vs References
Replies
7
Views
75
kjv1611
kjv1611
CrystalFacets
  • Locked
  • Question
Excel 2013 Uploaded to Google Sheets - Formulas Removed 1
Replies
7
Views
98
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top