Windows Forum

Ask something
Discussion Locked

Comma Space causes cell break Excel 2002

0 helpful
4 replies

by malisa.evans

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
When pasting text into Excel 2002, the data is breaking up into two different cells if there is a ", ". Is there a settings or custom option I can change to prevent this? The data is coming from an Oracle application, therefore paste special is not an option.

4 replies

by dklippert

Pate into a test file. If you can change the file extension to something like DAT, the wizard will allow you to custom parse when you import the data

by malisa.evans

Pasting it into a text file works, however this seems rather cumbersome. I have 100 people doing this up to 4 times a day. Isn't there a setting or something I can just change?

by dklippert

Have you looked into Web Queries? Take a look at the help file. If you can copy and then paste, you may be able to use a query to bring in the information and parse it. Please describe how you are capturing the data.

by malisa.evans

I realized the only reason it was pasting comma delimited was because I had opened a text file as comma delimited earler. Imagine results after opening a text file space delimited....The problem corrected itself when I reopened excel. All historical preferences vanished and it pasted the entire cell as I was hoping. Thanks for your help.

This discussion is closed to new replies.