Solved

Formaula does not copy correctly

Posted on 2011-09-21
2
199 Views
Last Modified: 2012-05-12
The data that I downloaded does not copy correctly.  I have a 17 digit value that I must split into 2 pieces; when I use the left(a1,11) or right(a1,6) formula and copy it, only the first entry copies correctly and it it the only value seen.  Attached is a sample of the spreadsheet.
EE-Copy-Issue.xls
0
Comment
Question by:castlerj
2 Comments
 
LVL 50

Accepted Solution

by:
barry houdini earned 500 total points
ID: 36575562
I can't see the problem - the first 11 characters are all the same aren't they - so =LEFT(A2,11) will give you the same thing when copied down.

If you use =RIGHT(A2,6)

that should give different values

If they look the same then re-calculate the sheet by pressing F9 key

regards, barry
0
 
LVL 27

Expert Comment

by:Glenn Ray
ID: 36575593
This is happening because you have automatic calculation turned off in your workbook.

To fix:
Excel 2003:
Menu:  Tools, Options, Calculation tab
Click the radio button for "Automatic" then click OK

Excel 2007:
Click the Office Button, then click "Excel Options" button on bottom
Click Formulas on left
Under Calculation options, click the radio button for "Automatic" then click OK.

-Glenn
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question