Forum Discussion
Creating a list (not columns) of comma separated values
I have a list of words (comma separated values) and want to know how to separate these words onto separate lines in the same column e.g. in column A line 1, 2, 3, 4, etc.
thanks, that looks good but I'm new to excel so have no idea how to use this formula to achieve the required result.
Put a screenshot of your input data then show your desired output. Better, attach a sample file to your post or comment so that we can look what you actually want?