Delete everything after a certain character?

[ThereThatGuy]

Hi, I was hoping someone could help me with this. How can I delete everything after a certain character (for this example: - ), no matter how much there is after - in each cell.

Or, is there a way that i can move everything after the "-" to an new cell?

Excel 2010

Thank you.
TTG

Thank you jeffreybrown It worked perfect!

[jeffreybrown]

Hello & Welcome to the Board,

Take a look at text to columns

http://excelhints.com/2010/01/29/usi...separate-data/

[Marcol]

Or try this

Please Login or Register  to view this content.

To get the remaining text

Please Login or Register  to view this content.

You might also want to wrap this in TRIM()

[ThereThatGuy]

Hello & Welcome to the Board,

Take a look at text to columns

http://excelhints.com/2010/01/29/usi...separate-data/

Wow that was easier than expected. Thank you sir!

[jeffreybrown]

Glad it worked for you...you're welcome