Trying to have Text to Columns (might be a little different from just using function)

[geniuswu06]

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

 

[dermie_72]

Highlight the range you want to adjust, make sure the column to the right is blank.
Click text to column
Delimited
other: put hyphen here
Click ok

 

[geniuswu06]

Neat!!

Thank you, dermie_72