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

Answer 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 »

Top Q&A For: In Excel, is it possible to set cells replace c...

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

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 »

How to Replace Blank Cells With Value in Excel 2003?

Manually replacing blank cells in a large Excel spreadsheet can be time-consuming. However, one function can make the job easy and fast. The search-and-replace feature, available in almost all Micr... Read More »

Can Excel 2003 display the count of the cells and also sum of the cells together in status bar ?

From what I am aware of, not in the normal everyday way. From version 2003 or earlier, you may only see one of the aggregate values at a time in the Status Bar area, by right-clicking and choosing... Read More »

Anybody tell me how to copy cells automatically in MS excel just by selecting cells by arrow key?

I am not sure why you would want to alter the typical functioning of the arrow keys, it would not be a wise decision. There are many shortcut key combinations of selecting cells within MS-Excel: ... Read More »