i need to edit several cells at a time, i know i can change/replace info with
the replace function.

But what if all the cells contain diferent info but the first word is common
and i want to keep only the first word.

ie.

EDP Spray - only 14 left
EDP Spray - only 4 left
EDT Spray - only 2 left


i Want to erase from the - forward just to sat

EDP
EDP
EDT

etc...

try this:

Select the single-column range of cells to be impacted

If all of the first words are the same length:
From the Excel Main Menu:
<data<text-to-columns
Check: Fixed Width........Click [Next]
....Leave the breakpoint after the first word
....Dbl-Click all others to remove them
Click [Next]
Click on the 2nd column......Check: Do not import (skip)
Click [OK]

If the first words have various lengths
From the Excel Main Menu:
<data<text-to-columns
Check: Delimited........Click [Next]
Check: SPACE...........Click [Next]
Click on the 2nd, 3rd, etc columns......Check: Do not import (skip)
Click [OK]

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Gmata" wrote in message
...
i need to edit several cells at a time, i know i can change/replace info
with
the replace function.

But what if all the cells contain diferent info but the first word is
common
and i want to keep only the first word.

ie.

EDP Spray - only 14 left
EDP Spray - only 4 left
EDT Spray - only 2 left


i Want to erase from the - forward just to sat

EDP
EDP
EDT

etc...

Yes thank you very much

"Ron Coderre" wrote:

try this:

Select the single-column range of cells to be impacted

If all of the first words are the same length:
From the Excel Main Menu:
<data<text-to-columns
Check: Fixed Width........Click [Next]
....Leave the breakpoint after the first word
....Dbl-Click all others to remove them
Click [Next]
Click on the 2nd column......Check: Do not import (skip)
Click [OK]

If the first words have various lengths
From the Excel Main Menu:
<data<text-to-columns
Check: Delimited........Click [Next]
Check: SPACE...........Click [Next]
Click on the 2nd, 3rd, etc columns......Check: Do not import (skip)
Click [OK]

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Gmata" wrote in message
...
i need to edit several cells at a time, i know i can change/replace info
with
the replace function.

But what if all the cells contain diferent info but the first word is
common
and i want to keep only the first word.

ie.

EDP Spray - only 14 left
EDP Spray - only 4 left
EDT Spray - only 2 left


i Want to erase from the - forward just to sat

EDP
EDP
EDT

etc...