Formatting Problem

[ashley319]

I normally put orders into an excel spreadsheet that includes customer name address and order number. Normally when I copied and pasted(paste special, text only) this information into excel it looked perfect. The entire name was in 1 cell the entire address in another. Something has changed though. It is now separating every word/number into a different cell so an address that took up one cell is now taking up 8. Every time there is a space it creates a new cell. I don't know what got changed but whatever it was it was accidental and I have no idea how to get it back to where it was. HELP!!!

 

[VoG]

I suspect that you have used Text to Columns.

Select a cell with data in it, Data > Text to Columns, tick Delimited then click Next. Untick all the options then click Cancel.

 

[ashley319]

I just tried what you said but it just moved everything into one cell. I'm looking for the same spacing I had before. Not everything in it's own cell and not everything in one. It used to group them the same way as the document I was copy/pasting from. But thank you for trying to help.

 

[ashley319]

actually i lied it is in fact fixed. Thank you so much!!!!