pasted column splits at spaces

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a single column in SQL query analyzer data. I copy the one column to a
single column into Excel and it creates a new column for ever space...
so "client without insurance" become A Client, B Without, C insurance.
It didn't used to do this.
 
Sounds like you have spaces set as a delimiter for new columns. Check you
settings.
 
You must log in or register to reply here.

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

Similar Threads

Split column contents (de-concantenate) 7
Function that will look at letter in a column and return a number 3
Possibly an IF function? 1
Spacing in Column headers 1
Summing one column based on criteria from two other columns 2
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Paste Delimited 8
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2

Back
Top