How to split the content of a cell?

Hi I need to split the content of a cell into one column and auto insert multiple rows depending on count of words for each cell as the following A B 1 How are you 2 Are you ready Results Split words of cell A1 into colmun B and insert two blank rows and split words of cell A2 and insert 5 blank rows ( count of words in a cell ) into column B to become as below A B 1 How are you How 2 are 3 you 4 Are you read my son Are 5 you 6 ready 7 my 8 son Thanks, Ahmad Roz

Explorer Asked on 25th June 2016 in Excel for Windows.
Add Comment
  • 0 Answer(s)
  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of use.