CODEWITHSUNDEEP
excel
createcode
createcode

Reputation: 147

Excel - convert newline (alt+enter) single cell content to different rows

imgI have some content in an excel cell in the form of numbers separated by alt + enter (newline), how could I transfer all content to different rows?img (actually first image should be the second)

enter image description here

Upvotes: 1

Views: 474

Answers (2)

createcode
createcode

Reputation: 147

img But if we have an additional column like in the picture, how can be the job done?

Upvotes: 0

John Robert
John Robert

Reputation: 56

Or you can follow this.

Your text with "alt-Enter"

enter image description here

Click data then text to columns

enter image description here

Follow this settings

enter image description here

enter image description here

Upvotes: 1

Related Questions