+ Reply to Thread
Results 1 to 3 of 3

Copying values without blanks

  1. #1
    Registered User
    Join Date
    04-21-2014
    Location
    Cuernavaca
    MS-Off Ver
    Excel 2007
    Posts
    22

    Copying values without blanks

    Hi everyone, I was copying some data from a Excel and I've noticed that when I copy the cell and put the information in other place, for example in a note of Notepad I got the value of the cell between two spaces, for example if in my cell appears the value = "Hello World!", in the note I would get " Hello World! ". Why does this happens and how can I get the value without spaces? Thanks everyone!

  2. #2
    Forum Contributor
    Join Date
    01-28-2010
    Location
    Pittsburgh, PA
    MS-Off Ver
    Excel 2013
    Posts
    200

    Re: Copying values without blanks

    Can you share? I haven't seen this and I cannot replicate your error in the way you described. Where are you cutting and pasting to?

  3. #3
    Registered User
    Join Date
    04-21-2014
    Location
    Cuernavaca
    MS-Off Ver
    Excel 2007
    Posts
    22

    Re: Copying values without blanks

    I've solved that, it's because I use this format in every cell:
    Please Login or Register  to view this content.
    I don't know why but that format put the spaces, so I've restricted the format to the part that I have numeric values, and that's all. Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Copying cells but not blanks
    By Cmorgan in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 05-28-2013, 05:18 AM
  2. Copying certain cells if there are blanks formula
    By Jonsby in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-21-2013, 01:36 PM
  3. Copying certain cells if there are blanks formula
    By Saber in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-11-2010, 09:19 AM
  4. Copying dynamically from one sheet to another without blanks
    By fynn in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-06-2008, 01:16 AM
  5. Copying data into another column but without blanks
    By sandydude4u in forum Excel General
    Replies: 2
    Last Post: 05-31-2007, 04:12 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1