Text to column, fixed width

D

Daniel

I have a chart based on imported data from a database. The problem is after
anytime I refresh data, the chart is colasped, all data become straight line
at 0. I have to click data/text to column/fixed width/finish to get my chart
back.

My question: How can I format the worksheet so that I don't have to do this
after refresh data?

Thanks
Daniel
 
B

Bernard Liengme

You could record a macro to do the import followed by the parsing
(text-to-columns)
best wishes
 
D

Daniel

Hi Bernard
I did that but it took the same amout of clicks. Tool/macro/choose sub/run
Don't know how to format so that I can get rid of this task: text to
column/fixed width after refresh data.
Thanks
Daniel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top