Excel question

The HG · 05-13-2008, 05:39 PM

Is there any way to separate the contents of a cell without doing it manually?

Basically I've got a list of cells, all with a team name and an odds number in each one, and I want to split the cells into two, one with the team name, and one with the number.

So right now in each cell I have:

Boston -120
NY +110

etc etc

and I want to split up those cells into two distinct columns, one with the team and one with the number, and I'm wondering if there is any way to do that without doing each one manually.

I haven't been able to find a way.

element1286 · 05-13-2008, 05:42 PM

There is a text to columns option on the data menu. It is pretty straight-forward to use.

jjgold · 05-13-2008, 05:45 PM

I know you have to use phrases like this but you need to play with it

=RIGHT(A1,LEN(A1)-MAX(IF(MID(A1,ROW(INDIRECT("1:"&LEN(A1)) ),1)=" ",ROW(INDIRECT("1:"&LEN(A1))),0)))

LT Profits · 05-13-2008, 06:02 PM

Data/Text to Columns/Delimited/Space

durito · 05-13-2008, 06:03 PM

As JJ alludes.

You can use the commands LEFT, RIGHT, and MID to separate.

Willie Bee · 05-13-2008, 06:05 PM

I've always just done it the way element and LT suggest, HG.

durito · 05-13-2008, 06:05 PM

Do it like this:

=RIGHT(Cell,4)

With 4 being 4 places from the right, then copy through the other cells

The HG · 05-13-2008, 06:11 PM

wow totally worked, thanks guys