locked
Copying from Excel to Word table, and extra space in first column RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi all,

    I'm trying to copy data from an excel sheet to a word document for a report. Since I have A LOT of data, I do not want to keep having to delete spaces every time I copy something over. I've attached two pictures. In one you can see the spaces that are getting carried over (I can't delete them because I need the info from columns B:I. In the second picture you can see that I have to delete the spaces in every one, manually, each time. There's about 6000 entries altogether that I'd have to delete. 

    I can't attach pictures because my account isn't verified, but if you need any further description, let me know. Any help is appreciated, even the hard truth.


    Thursday, May 3, 2018 10:38 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hey,

    i think i can  help you out but i didn't find any picture attached for reference. reply with the screenshot please

    Friday, May 4, 2018 12:54 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    If "spaces" mean "space characters," you can delete them in Word by replacing a space character with nothing.

    Stefan Blom, Microsoft Word MVP

    Friday, May 4, 2018 5:46 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi, 

    Just checking in to see if the information of Stefan Blom was helpful. Please let us know if you would like further assistance.

    Regards,

    Emi

    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.


    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    Monday, May 7, 2018 9:11 AM