PDA

View Full Version : Solved: Remove all lines



Tenspeed39355
11-27-2007, 01:13 PM
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

mdmackillop
11-27-2007, 02:15 PM
Hi Max,
A sample would help.

Tenspeed39355
11-27-2007, 04:58 PM
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