How can i Edit many Cells at a time.

G

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

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)
 
G

Gmata

Yes thank you very much

Ron Coderre said:
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 said:
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...
Click to expand...
Click to expand...
 
Top