Thursday, November 21

Split Or Extract The Data Having More Than One Line In Single Cell

  1. To Extract Or Split These Type Of Data Please Follow The Step Shown Below.
  2. First Select The Cell Having That Kind Of Data.
  3. Copy The Cell.
  4. Now Open The Note Pad.
  5. Remove Double Quote From Start Point And From End Point.
  6. Now Copy All Data From Notepad Ctrl + A.
  7. Now Go To Excel And Select The Same Range Or Cells Or Whole Column Where You Want The Data To Get Populate.
  8. Now Right Click And Paste As Text And You Will Have All Those Data In Separate Cells.
  9. Now If Needed Copy Those Data And Transpose T o Column From Rows.
  10. That’s It 🙂

Leave a Reply

Your email address will not be published. Required fields are marked *