copy text with comma eliminated

K

Kent

Dear all,

I have a series of text seperate by comma in Column A

A
shop, table, toy, car
mon, light, book
radio, phone

now I want to copy them one by one to Column B, with the comma eliminated

B
shop
table
toy
car
mon
light
book
radio
phone

How to do it by formula?


thanks

Kent
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Formating bolded text exclusively. 0
List all tables, including document structure 0
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Auto Filter Comma Dilemiation 2
Need to Match Multiple Results and Count Text in Different Column 4
Combining three files when middle file has sections with endnotes 2
Function or Sub to help with text string 5

Top