SOLVED

Copy numerical data from a column in Excel to another column

%3CLINGO-SUB%20id%3D%22lingo-sub-2660399%22%20slang%3D%22en-US%22%3ECopy%20numerical%20data%20from%20a%20column%20in%20Excel%20to%20another%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2660399%22%20slang%3D%22en-US%22%3E%3CP%3EColumn%20G%20in%20my%20Excel%20worksheet%20contains%20numerical%20data%20that%20were%20calculated%20using%20a%20formula%2C%20based%20on%20given%20numerical%20data%20that%20appear%20in%20same%20corresponding%20rows%20in%20columns%20B%20and%20C.%3C%2FP%3E%3CP%3EI%20want%20to%20copy%20just%20the%20numerical%20values%20that%20now%20appear%20in%20column%20G%20into%20another%20empty%20column%20H%2C%20or%20into%20an%20available%20empty%20column%20(say%2C%20column%20B)%20in%20a%20new%20Excel%20worksheet.%3C%2FP%3E%3CP%3EI%20seem%20unable%20to%20do%20simple%20copying%20(CTRL%20C%2C%20CTRL%20V)%2C%20as%20the%20target%20column%20(H%2C%20or%20B)%20gets%20filled%2C%20in%20one%20case%20with%20different%20numerical%20data%20and%20not%20the%20same%20data%20from%20G%2C%20and%20in%20another%20case%20it%20gets%20filled%20with%20REF!%20instead%20of%20numerical%20values%20of%20the%20data.%3C%2FP%3E%3CP%3ESo%2C%20how%20to%20copy%20numerical%20data%20as%20they%20appear%20in%20the%20source%20column%20G%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2660399%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2660427%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20numerical%20data%20from%20a%20column%20in%20Excel%20to%20another%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2660427%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1131310%22%20target%3D%22_blank%22%3E%40benzij%3C%2FA%3E%26nbsp%3BPaste%20Values%20in%20stead.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-08-18%20at%2014.42.54.png%22%20style%3D%22width%3A%20137px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F304036i3ED1D1672B637F90%2Fimage-dimensions%2F137x268%3Fv%3Dv2%22%20width%3D%22137%22%20height%3D%22268%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-08-18%20at%2014.42.54.png%22%20alt%3D%22Screenshot%202021-08-18%20at%2014.42.54.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Column G in my Excel worksheet contains numerical data that were calculated using a formula, based on given numerical data that appear in same corresponding rows in columns B and C.

I want to copy just the numerical values that now appear in column G into another empty column H, or into an available empty column (say, column B) in a new Excel worksheet.

I seem unable to do simple copying (CTRL C, CTRL V), as the target column (H, or B) gets filled, in one case with different numerical data and not the same data from G, and in another case it gets filled with REF! instead of numerical values of the data.

So, how to copy numerical data as they appear in the source column G?

1 Reply
best response confirmed by benzij (Occasional Visitor)
Solution

@benzij Paste Values in stead.

Screenshot 2021-08-18 at 14.42.54.png