Results 1 to 3 of 3
  1. #1
    The Eternal Optimist zimmy's Avatar
    Join Date
    January 18th, 2005
    Location
    NC
    Posts
    696
    Can you help with an Excel question?
    I am a little stuck.

    I have a spreadsheet and I've combined columns A and B using Concatenate function into column C.

    What I want to do is take the data in column C and move it to an entirely different spreadsheet. When I try to do that I loose the reference to columns A and B.

    Is there a way I can do this? Thanks much!



    ~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*

    The big shots are only the little shots who keep shooting.
    -Christopher Morley

  2. #2
    ABW Ambassador Nature Boy's Avatar
    Join Date
    January 18th, 2005
    Location
    Tennessee
    Posts
    1,423
    1. Select the whole column that you want to copy
    2. Use the Copy command
    3. Select the new columnn where you want the results
    4. Click Edit (at the top of Excel)
    5. Click Paste Special
    6. Select the check box for Values
    Scott
    If you can't dazzle them with brilliance, then baffle them with bulls#!t
    Don't tell me that you'll do it... SHOW ME.
    Just because everyone else is drinking it is no reason for me to drink the KOOL-AID.

  3. #3
    The Eternal Optimist zimmy's Avatar
    Join Date
    January 18th, 2005
    Location
    NC
    Posts
    696
    Thank you Scott - I appreciate the help!



    ~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*

    The big shots are only the little shots who keep shooting.
    -Christopher Morley

  4. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. Question for MS Excel Guru's
    By jimh009 in forum Midnight Cafe'
    Replies: 5
    Last Post: March 12th, 2007, 03:45 AM
  2. Excel question
    By SSanf in forum Programming / Datafeeds / Tools
    Replies: 9
    Last Post: February 6th, 2006, 04:25 PM
  3. Excel/Datafeed Question
    By windowsguy in forum Programming / Datafeeds / Tools
    Replies: 2
    Last Post: April 20th, 2004, 01:46 PM
  4. Excel question
    By netsu in forum Midnight Cafe'
    Replies: 2
    Last Post: January 31st, 2004, 07:31 PM
  5. Excel Question
    By ~Michelle in forum Midnight Cafe'
    Replies: 2
    Last Post: January 21st, 2004, 02:02 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •