turning rows of text in excel into one continuous line of text

[cargo]

I hope someone can help with this.
I have downloaded a long list of stock codes from the
standardandpoors.com website.
The website allows one to do this and formats the download into one
column of an excel spreadsheet with many rows.
The list of codes, some 100 to 200 of them in any download, sit in
unique cells e.g. Cell A2 is BHP, Cell A3 is CBA, Cell A4 is DBA etc.
etc.
What I need to do is then transfer those codes into Watchlists I set up
in various free internet stock tracking websites - CBS Marketwatch is a
good example.
However, the Watchlists invariably ask one to enter the codes
horizontally usually separated by either a space or a comma.
Now I've already worked out that I can transpose the column of stock
codes into one long row of stock codes.
The problem is that when I insert the rows from excel into the
Watchlist, only the first code appears because each cell in the excel
row is separated by columns.
What I need to do is to find a way to format that long row of stock
codes so that there's no column breaks between stock codes and
hopefully format that row so there's just one space (or a comma)
between each code.
Then I can bulk enter those codes into the Watchlist in one go.
Any help would be much appreciated.
Kind regards,
Cargo

 

[CLR]

Try this.....assuming your data is in row 1........put a comma in cell A2
and this formula wherever you want.....

=A1&A2&B1&A2&C1&A2&D1&A2&E1&A2&F1 etc etc

Then, you can change cell A2 to a "space" or "dash" or anything you want as
a separator, and it will change throughout the formula.......

Vaya con Dios,
Chuck, CABGx3

 

[Beth Unglesbee]

Cargo,

Another option is to use the Save As drop down option for
a Comma Delimited data type. It should be listed as
something like: CSV Comma Delimited *.csv. Now here's
the tricky part. In order to check this file, close Excel
and open the saved file in Notepad. If you open it in
Excel, the application will try to disburse the data
across columns. Notepad will show the native format of
the file.

HTH
Beth
Microsoft MVP - Excel

 

[cargo]

Beth - thanks for the reply - much appreciated.

 

[Stephen Bye]

1) Select column A,
2) Use the Edit | Fill | Justify menu option,
3) Smile.