+ Reply to Thread
Results 1 to 15 of 15

Is there any way to copy and paste in desired format in excel

  1. #1
    Registered User
    Join Date
    07-13-2016
    Location
    Pakistan
    MS-Off Ver
    2007
    Posts
    11

    Is there any way to copy and paste in desired format in excel

    Like If I copy these all

    LEg5Z.png

    If you want to try here is the source url from where I'm copying you can try yourself --> http://www.wcsu.edu/com/faculty/


    and want outcome like this:

    SSLA5.png

    How can I do this?

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 10)
    Posts
    49,476

    Re: Is there any way to copy and paste in desired format in excel

    Why don't you use the solution you were given in the other thread? You could insert the list onto one sheet and have the formula working its magic on another.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  3. #3
    Registered User
    Join Date
    07-13-2016
    Location
    Pakistan
    MS-Off Ver
    2007
    Posts
    11

    Re: Is there any way to copy and paste in desired format in excel

    The last solution was good but there was little problem that some time there are 5 rows and some time 4 so it's messing everything if I go with formula.

  4. #4
    Registered User
    Join Date
    07-13-2016
    Location
    Pakistan
    MS-Off Ver
    2007
    Posts
    11

    Re: Is there any way to copy and paste in desired format in excel

    is there any way that I copy 1 screenshot items and paste and the outcomes will be like 2nd screenshot with that formula.

    Here's the source URL --> http://www.wcsu.edu/com/faculty/

    First 3 are 5 rows data while rest are 4 rows data. This is just a sample URL I need to copy in bulk. That's why for me formula option will not work.

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 10)
    Posts
    49,476

    Re: Is there any way to copy and paste in desired format in excel

    No way that I can think of, sorry.

  6. #6
    Registered User
    Join Date
    07-13-2016
    Location
    Pakistan
    MS-Off Ver
    2007
    Posts
    11

    Re: Is there any way to copy and paste in desired format in excel

    Let me wait If anyone with perfect solution comes up.

    Thanks AliGW for your help as well.

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 10)
    Posts
    49,476

    Re: Is there any way to copy and paste in desired format in excel

    You are welcome to wait for other answers, but if you post the same query on other forums, remember to provide links here.

  8. #8
    Registered User
    Join Date
    07-13-2016
    Location
    Pakistan
    MS-Off Ver
    2007
    Posts
    11

    Re: Is there any way to copy and paste in desired format in excel

    Actually I was not aware. Yes I'll be careful. I'm waiting if someone replies here. If someone don't answer I'll post another forum with link back to this thread.

  9. #9
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 10)
    Posts
    49,476

    Re: Is there any way to copy and paste in desired format in excel

    When you joined the forum recently you agreed to abide by the Forum Rules, but in haste I fear you might not have actually read them. Please stop and take a moment to read them now. We all follow these rules for the benefit of all, as must you. Thanks.

    (link above in the menu bar)

  10. #10
    Registered User
    Join Date
    07-13-2016
    Location
    Pakistan
    MS-Off Ver
    2007
    Posts
    11

    Re: Is there any way to copy and paste in desired format in excel

    Thank you, I'll follow all rules.

  11. #11
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    21,261

    Re: Is there any way to copy and paste in desired format in excel

    Along with many other contributors, I am not able to view .png files on this forum due to software incompatibilities with some browsers. Hence when you say:

    and want outcome like this:
    it is meaningless, as we can't see what your outcomes are.

    It would help if you attached a sample Excel workbook to show what you want to achieve. To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

    Hope this helps.

    Pete

  12. #12
    Registered User
    Join Date
    07-13-2016
    Location
    Pakistan
    MS-Off Ver
    2007
    Posts
    11

    Re: Is there any way to copy and paste in desired format in excel

    I did as you said. Hope now you can see the attachments.
    1st one is what I copy and 2nd one is what I want to see.
    Attached Images Attached Images

  13. #13
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    21,261

    Re: Is there any way to copy and paste in desired format in excel

    They are both images (pictures), so I still can't see them. If you really must upload pictures, then do so in the jpeg or pdf formats.

    Pete

  14. #14
    Registered User
    Join Date
    07-13-2016
    Location
    Pakistan
    MS-Off Ver
    2007
    Posts
    11

    Re: Is there any way to copy and paste in desired format in excel

    I convert both into pdf format. Hope it helps.
    Attached Files Attached Files

  15. #15
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    21,261

    Re: Is there any way to copy and paste in desired format in excel

    I think Ali's suggestion in Post #2 is correct (without having read your previous thread). Paste the data into one sheet, and then use another sheet with formulae in to put the data in the format you require. The formulae should be able to cope with 4-line and 5-line entries, if written appropriately.

    Pete

+ 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. Excel Copy & Paste and Format
    By stcxiong in forum Excel General
    Replies: 1
    Last Post: 02-02-2016, 06:20 PM
  2. Excel VBA to copy and paste from horizontal to vertical format
    By ennin12 in forum Excel Programming / VBA / Macros
    Replies: 27
    Last Post: 09-24-2015, 05:12 PM
  3. Converting to XML from Excel document; problems matching format desired with table
    By nibirue in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-12-2015, 02:21 PM
  4. can Sql query runs itself and paste result directly in the desired excel cells?
    By raksha1234 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-12-2014, 05:51 AM
  5. [SOLVED] Copy row based on value in col A + paste in new sheet, more than one value in "A" desired
    By LiLi1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-12-2013, 09:18 PM
  6. Macro Copy and Paste to create desired template
    By montroseite in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-10-2010, 04:15 AM
  7. Extracting text into desired format in Excel
    By mpendle in forum Excel General
    Replies: 6
    Last Post: 10-10-2009, 02:06 PM

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