| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
to replace a value in each cell of the column
Dear All,
In an excel have a column with a name 'TRANTYPE' ie in B1 cell in which contain the value 'I' and 'C'. 'I' for Invoice and 'C' for credit. I want to replace all the values in a cell as follows if the value is 'I' it should be replaced with 'Invoice' if the value is 'C' it should be replaced with 'Credit' in all the cell of that column. Please help . Pol |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to search in one column, and replace in the other column if fo | Excel Discussion (Misc queries) | |||
| Can I replace a ' at the beginning of a text cell using Replace | Excel Discussion (Misc queries) | |||
| Find and Replace on just One Column | Excel Discussion (Misc queries) | |||
| Replace all non blanks in a column with column header | Excel Discussion (Misc queries) | |||
| Find and Replace in a column | New Users to Excel | |||
Threaded Mode
