geniuswu06
New Member
- Joined
- Oct 11, 2011
- Messages
- 12
Hi guys,
I have a list of elements on my excel sheet.
The column that I need to do 'text to column' looks something like this
MDL1-Men's Wear
MODL1-Women's Wear
MODEL2-Fragrance
MODEL3-Maagzines
...
I just want to split the contenet before the hyphen and after that into two seperate columns?
Do anyone happen to know how to do that?
Fred
I have a list of elements on my excel sheet.
The column that I need to do 'text to column' looks something like this
MDL1-Men's Wear
MODL1-Women's Wear
MODEL2-Fragrance
MODEL3-Maagzines
...
I just want to split the contenet before the hyphen and after that into two seperate columns?
Do anyone happen to know how to do that?
Fred