Skip to content
Split Or Extract The Data Having More Than One Line In Single Cell
Post Views: 372
- To Extract Or Split These Type Of Data Please Follow The Step Shown Below.
- First Select The Cell Having That Kind Of Data.
- Copy The Cell.
- Now Open The Note Pad.
- Remove Double Quote From Start Point And From End Point.
- Now Copy All Data From Notepad Ctrl + A.
- Now Go To Excel And Select The Same Range Or Cells Or Whole Column Where You Want The Data To Get Populate.
- Now Right Click And Paste As Text And You Will Have All Those Data In Separate Cells.
- Now If Needed Copy Those Data And Transpose T o Column From Rows.
- That’s It 🙂