yati_pulis
New Member
- Joined
- Apr 24, 2014
- Messages
- 1
Is there a formula for pulling text from one cell with multiple words separated by commas to rows.
Currently I'm using the 'text to columns' function to extract the multiple words in one cell into multiple columns and then I take all the columns and 'transpose' them into rows using the 'special paste' function.
I'm using Microsoft Excel for Mac 2011.
Currently I'm using the 'text to columns' function to extract the multiple words in one cell into multiple columns and then I take all the columns and 'transpose' them into rows using the 'special paste' function.
I'm using Microsoft Excel for Mac 2011.
