Thread: to replace a value in each cell of the column
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
  
Posts: 9,221
Default to replace a value in each cell of the column
Select the range, then use Edit Replace
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"pol" wrote:
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.

Reply With QuoteReply With Quote