i have a comma problem

[Pivotrend]

how do i separate historical stock prices from yahoo in different
columns rather being in 1 column like in picture attached?

help

Attachment filename: image4.gif
Download attachment: http://www.excelforum.com/attachment.php?postid=481699

 

[Phoenix]

Hi!

Try Data-->Text to Columns-->Fixed With. Here you can adjust were t
separate

Phoeni

 

[Pivotrend]

didnt work
i want to update this information Dail

 

[Andy B]

Hi

Rather than using fixed width, use delimited, with a comma as the separator.

Andy.

 

[Pivotrend]

yes but when i update it all returns back like it was in column A al
information in one column not separated
:

 

[Pivotrend]

k guys & gals

i have this information in Cell A1
Date,Open,High,Low,Close,Volume,Adj

can i copy only the word Date in Cell A2
then Open in Cell B2
then High in Cell C2
then Low in Cell D2
then Close in Cell E2
then Volume in Cell F2

is that Possible

 

[Rollin_Again]

It's already been explained above. It works! Just follow these steps

Highlight column by clicking on Column Letter

On top of workbook click DATA --> TEXT TO COLUMNS

When the Text to Columns Wizard opens click the radio button labele
"Delimited" and click NEXT.

Uncheck all boxes except the box labeled "COMMA" and change tex
qualifier drop down to read "NONE"

Column seperator lines will appear

Click Finish





Rolli

 

[Pivotrend]

Rollin_Again
STILL...........


when i update all new information come in Column A with commas?

how can i automatically Separate commas when i download informatio
with commas

 

[Rollin_Again]

That's very strange. I manually entered the information exactly as i
appears in the picture you attached and when I followed the steps i
worked just fine. Can you attach a sample of the data either in a
Excel file or tell me where I can obtain the exact data you are tryin
to seperate?

Rolli

 

[Pivotrend]

Rollin_Again

Again
like i said it worked ((( BUT ))) when i update the information in A2
get All the new information in Column A with the commas Agai

 

[Rollin_Again]

The only way to have this process occur automatically when you updat
the workbook is to add some VBA code to your project. This code woul
be executed when the Worksheet_Change event occurs. This is not har
to do but requires a minimal amount of knowlege of VBA events an
procedures? Do you feel comfortable trying this if you had a littl
help?

By the way, how do you update the data in the workbook? Are yo
copying and pasting the data from somewhere into the same workbook eac
day? Are you creating a new workbook for each day? Describe for me i
detail how you "Update" the data and I will try to help you out.



Rolli

 

[AlfD]

Hi!

You could record a macro by doing the data > text to columns routin
once with macro recorder switched on.

Thereafter, you could use the macro either "at the press of a button
or triggered by some other event (maybe loading the data - though
haven't given much thought to that latter line).

Al