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 »

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 »

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 »

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 »

How do I condense data in an excel table to fit within 1 column and not overlap into the 2nd column?

Select the column you wish to modify. Right-click that selected area and choose Format Cells... Then go to the Alignment tab and set the Text Control to "Wrap text". Now click the OK button.Whil... Read More »