vidyavallaba
New Member
- Joined
- Dec 17, 2013
- Messages
- 42
Hello,
I am a new user.
I need a formula to separate text and place them into new cell.
example: a1:red,blue,green,yellow,.....
a2:red
a3:blue
a4:green
a5:yellow
i need excel formula to do this.Not text to column function or macros
can any one please help me.
I am a new user.
I need a formula to separate text and place them into new cell.
example: a1:red,blue,green,yellow,.....
a2:red
a3:blue
a4:green
a5:yellow
i need excel formula to do this.Not text to column function or macros
can any one please help me.