Just a quick parse?

  • Thread starter Thread starter ste mac
  • Start date Start date
S

ste mac

Hi everyone, just a quick question...
If I had 01-03 in a cell (say G2) how would I get the cell to split
the data so that it had (01 in H2) and (03 in I2) then I could drag it
down the column doing them all? I've tried a couple of methods but I
am just not getting anywhere!

thanks a lot...

seeya ste
 
I'm not exactly sure what you are wanting to do but . . . Either the Text to
Columns feature or one of the text functions (i.e. Left, Right, or Mid)
should do the trick.

Craig Huggart
Microsoft XP Master Instructor
(e-mail address removed)
 
DATA>TEXT TO COLUMNS
That should do it.

Hi everyone, just a quick question...
If I had 01-03 in a cell (say G2) how would I get the cell to split
the data so that it had (01 in H2) and (03 in I2) then I could drag it
down the column doing them all? I've tried a couple of methods but I
am just not getting anywhere!

thanks a lot...

seeya ste
 
Select the column and go to Data > Text to Columns. Use
the "-" as your delimiter (type it in the "Other" box)..

HTH
Jason
Atlanta, GA
 
Data|Text to Columns, check delimited, Next, check other and insert -,
Next, insert H2 for the destination, Finish.

Alan Beban
 
Back
Top