Results 1 to 6 of 6

Thread: Macro for copying the contents of a cell to the Windows clipboard

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. 01-10-2013, 02:53 AM #1
    rollis13
    rollis13 is offline
    Member rollis13's Avatar
    Join Date
    Nov 2012
    Posts
    36
    Rep Power
    0
    Infact, they shouldn't be there. The quotation marks are there just because of the line breaks. How is your concatenation formula ? can you rearrange it ?

    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    https://www.youtube.com/watch?v=oVb1RfcSHLM&lc=UgwTq-jZlZLnLQ5VB8Z4AaABAg.9Hroz-OyWog9tYjSMc1qjA
    https://www.youtube.com/watch?v=0pbsf6sox34&lc=Ugxp9JFvvejnqA68W1t4AaABAg
    https://www.youtube.com/watch?v=kfQC-sQxMcw&lc=UgyCxQWypNIhG2nUn794AaABAg.9q1p6q7ah839t UQl_92mvg
    https://www.youtube.com/watch?v=vXyMScSbhk4&lc=UgyOh-eR43LvlIJLG5p4AaABAg.9isnKJoRfbL9itPC-4uckb
    https://www.youtube.com/watch?v=vXyMScSbhk4&lc=Ugy1B1aQnHq2WbbucmR4AaABAg. 9isY3Ezhx4j9itQLuif26T
    https://www.youtube.com/watch?v=vXyMScSbhk4&lc=UgxxajSt03TX1wxh3IJ4AaABAg. 9irSL7x4Moh9itTRqL7dQh
    https://www.youtube.com/watch?v=vXyMScSbhk4&lc=Ugxa2VYHMWJWXA6QI294AaABAg. 9irLgSdeU3r9itU7zdnWHw
    https://www.youtube.com/watch?v=vXyMScSbhk4&lc=UgwJAAPbp8dhkW2X1Uh4AaABAg. 9iraombnLDb9itV80HDpXc
    https://www.youtube.com/watch?v=vXyMScSbhk4&lc=UgzIzQ6MQ5kTpuLbIuB4AaABAg. 9is0FSoF2Wi9itWKEvGSSq
    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    Last edited by DocAElstein; 09-22-2023 at 04:04 PM.
    Reply With Quote Reply With Quote
  2. 01-10-2013, 10:42 PM #2
    isabelle r
    isabelle r is offline
    Junior Member
    Join Date
    Jan 2013
    Posts
    3
    Rep Power
    0
    Quote Originally Posted by rollis13 View Post
    Infact, they shouldn't be there. The quotation marks are there just because of the line breaks. How is your concatenation formula ? can you rearrange it ?
    The formula is:

    =A1&" "&A2&"

    "&A3
    Reply With Quote Reply With Quote
  3. 01-11-2013, 02:29 AM #3
    rollis13
    rollis13 is offline
    Member rollis13's Avatar
    Join Date
    Nov 2012
    Posts
    36
    Rep Power
    0
    Why couldn't your formula be like this: =A1&" "&A2&" "&A3
    This doesn't have line breaks and doesn't add quotation marks to your copy/paste.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Macro To Update Data in Cell Based On Value In Adjacent Cell
    By Howardc in forum Excel Help
    Replies: 2
    Last Post: 05-30-2013, 07:28 PM
  2. Macro for if cell A2 has text then cell B2 must have numeric value.
    By Carlos Arruda in forum Excel Help
    Replies: 5
    Last Post: 03-09-2013, 09:01 AM
  3. Macro for Opening files and copy the contents of the File
    By ravichandavar in forum Excel Help
    Replies: 16
    Last Post: 08-15-2012, 09:17 PM
  4. Macro to create files as per the contents in a column
    By Praveen Bj in forum Excel Help
    Replies: 1
    Last Post: 07-05-2012, 09:07 PM
  5. Listview not working in Windows 7 - 32 bit
    By Rasm in forum Excel Help
    Replies: 2
    Last Post: 07-09-2011, 07:40 PM

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
  •  

Forum Rules