Consulting

Results 1 to 3 of 3

Thread: Solved: Remove all lines

  1. 11-27-2007, 01:13 PM #1
    Tenspeed39355
    Tenspeed39355 is offline
    VBAX Tutor
    Joined
    Sep 2004
    Posts
    293
    Location

    Solved: Remove all lines

    Good afternoon I have a ss that has symbols in column A. I have transposed them to a horizontal line. I want to copy the symbols from row
    B2:B50 to a watch list with a broker account I have. There is a vertical line between all the symbols that is part of Excel. How can I remove all the vertical lines and insert a coma between each symbol? Thanks for
    any help with this.
    Max
    Reply With Quote Reply With Quote
  2. 11-27-2007, 02:15 PM #2
    mdmackillop
    mdmackillop is offline
    Administrator
    VP-Knowledge Base     VBAX Grand Master mdmackillop's Avatar
    Joined
    May 2004
    Location
    Scotland
    Posts
    14,489
    Location
    Hi Max,
    A sample would help.
    MVP (Excel 2008-2010)

    Post a workbook with sample data and layout if you want a quicker solution.

    To help indent your macros try Smart Indent

    Please remember to mark threads 'Solved'
    Reply With Quote Reply With Quote
  3. 11-27-2007, 04:58 PM #3
    Tenspeed39355
    Tenspeed39355 is offline
    VBAX Tutor
    Joined
    Sep 2004
    Posts
    293
    Location

    removing lines in Excel

    Hi guys I found the answer in Excel. All I had to do was elect to
    remove grid lines and that took care of the problem.
    Thanks anyhow
    Max
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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