ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   I think I found a bug and need to kow how to get it resolved (https://www.excelbanter.com/setting-up-configuration-excel/5093-i-think-i-found-bug-need-kow-how-get-resolved.html)

DMDiamond

I think I found a bug and need to kow how to get it resolved
 
when I run text to columns on a text string in excel I find that everything I
paste after that is also seperated and even in a new window it is already
broke down. would be nice excpet I cannot create a macro to handle this task
as the cells don't stay in the same place. When I close this file and reopen
it...it reverst to the default.

Dave Peterson

You don't like the way excel tries to help???

If no, just run another
data|text to columns
choose delimited
but uncheck all the delimiters.

Then test it out.

DMDiamond wrote:

when I run text to columns on a text string in excel I find that everything I
paste after that is also seperated and even in a new window it is already
broke down. would be nice excpet I cannot create a macro to handle this task
as the cells don't stay in the same place. When I close this file and reopen
it...it reverst to the default.


--

Dave Peterson


All times are GMT +1. The time now is 11:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com