How can i Edit many Cells at a time.

[Gmata]

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...

 

[Ron Coderre]

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]

Yes thank you very much

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)

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...