CODEWITHSUNDEEP
excelwindows
user3133542
user3133542

Reputation: 1715

Excel : how to paste data in one column?

lets say we have following data:

enter image description here

When I try to paste this into Excel, the selection windows occupies two columns:

enter image description here

Why? Is there a way to fix this? I want only one column!

Upvotes: 0

Views: 4431

Answers (1)

Moacir
Moacir

Reputation: 627

Excel considers ; as a column separator. This is why.

You can replace this by going on excel DATA tab, then on Text to column, choose Delimited and on the next screen, uncheck Semicolon and Finish.

This will disable semicolons as column separator when you paste it.

Upvotes: 2

Related Questions