Question

 MS Excel: How do you delete the last three characters of all cells in a column?

Answer If you knew for sure that the last three characters were always the same value (or were something similar enough to allow the use of "wildcard" characters), then a simple Find/Replace would work (C... Read More »
http://answers.yahoo.com//question/index?qid=20090623082846AApYHvu

Top Q&A For: MS Excel: How do you delete the last three cha...

Making a drop down list in all cells of a column in MS Excel 2007?

Based upon the information you have given, using the Data Validation method is the best way to handle this.Just select the column of cells that you want to have the drop-down choices within. The g... Read More »
http://answers.yahoo.com//question/index?qid=20090614070148AAjJ4Df

In Excel, is it possible to set cells replace certain characters with others (read for info)?

There are ways to make characters change automatically to other characters. And this usually ends up being handled through VBA code, normally at the "Worksheet_SelectionChange" routine or at the "... Read More »
http://answers.yahoo.com//question/index?qid=20090801082907AAHGvQ7

How Do I Delete Duplicate Cells in Excel?

Open an Excel document that contains duplicate cells. Highlight all the cells you want Excel to check for duplicates. Click on the "Data" tab, and then click the button labeled "Remove Duplicates."... Read More »
http://www.answerbag.com/q_view/2061334

Excel - make data automatically populate in one column based on value in another column?

The answer depends on how many "Fruits" there will be that a "Price" needs to be set for. And the VLOOKUP function would be one way of handling this.I would probably have the Fruit and Price value... Read More »
http://answers.yahoo.com//question/index?qid=20090702172651AAaZlSL


feedback
loading