| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i delete some information from different cells at time
samuel12.123.1456.125 revenue accuracy
samuel12.123.1456.125 revenue accura samuel12.123.1456.1revenue accuracy samuel12.16.1revenue accuracy sa12.123.1456.125annual income samuel3.1456.125annual income samuel12.123.1456.125 annual income how do i delete revenue accuracy and annual income without disturbing other data in the cell |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i delete some information from different cells at time
You could use Find and Replace - the replace value would be blank
HTH Sheila "maddy" wrote: samuel12.123.1456.125 revenue accuracy samuel12.123.1456.125 revenue accura samuel12.123.1456.1revenue accuracy samuel12.16.1revenue accuracy sa12.123.1456.125annual income samuel3.1456.125annual income samuel12.123.1456.125 annual income how do i delete revenue accuracy and annual income without disturbing other data in the cell |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i delete some information from different cells at time
Just do a 'Replace' (Ctr+H) and in the 'Find What' field put 'annual income' and in the 'Replace With' field, leave it blank. Think that'll do it. SamuelT -- SamuelT ------------------------------------------------------------------------ SamuelT's Profile: http://www.excelforum.com/member.php...o&userid=27501 View this thread: http://www.excelforum.com/showthread...hreadid=544757 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i delete some information from different cells at time
You can do it with the menu option Edit-Replace, type "revenue accuracy" in
the "Find what" field, and leave "replace with" blank. You can repeat for "annual income" If you want to do it with formulas, you can use something like: =SUBSTITUTE(A1,"revenue accuracy","") Hope this helps, Miguel. "maddy" wrote: samuel12.123.1456.125 revenue accuracy samuel12.123.1456.125 revenue accura samuel12.123.1456.1revenue accuracy samuel12.16.1revenue accuracy sa12.123.1456.125annual income samuel3.1456.125annual income samuel12.123.1456.125 annual income how do i delete revenue accuracy and annual income without disturbing other data in the cell |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
| Enter Time in cells | Excel Discussion (Misc queries) | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| Delete text in cells but keep formula | Excel Worksheet Functions | |||
| Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Linear Mode
