LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 41
Default How can i Edit many Cells at a time.

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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple users edit same spreadsheet at same time? ufcadmin Excel Discussion (Misc queries) 1 September 14th 07 05:24 PM
edit more than one Hyperlink at a time Clark Excel Worksheet Functions 0 May 26th 06 08:52 PM
Edit Macro 1st time use sparx Excel Discussion (Misc queries) 1 March 12th 06 04:04 PM
how to edit all 10 bubble data labels at the same time [email protected] Excel Discussion (Misc queries) 4 February 19th 06 08:31 PM
Edit query takes a long time TonyL Excel Worksheet Functions 0 May 11th 05 10:50 PM


All times are GMT +1. The time now is 03:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"