Prev: Help on Custom Task Pane in Excel 2007 using Managed code...
Next: Error can't Find File
From: Rachel D on 7 Apr 2010 10:14
All;

Need to do a search and replace on multiple values: 06 - Phase VI
would be replaced by O, 08 - Won would be replaced by W, 09 - Lost
would be replaced by L, 10 - Cancelled by Gov't would be replaced by C

I've looked for formulas, but what I've turned up is multiple values
to one value e.g. $ or - to blank.

Any help would be appreciated!
From: ryguy7272 on 7 Apr 2010 11:02
Well, the easiest way would be: Ctrl+F > Replace > Find what (type in your
criteria) > Replace with (type in your criteria) > Replace All.

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Rachel D" wrote:

> All;
>
> Need to do a search and replace on multiple values: 06 - Phase VI
> would be replaced by O, 08 - Won would be replaced by W, 09 - Lost
> would be replaced by L, 10 - Cancelled by Gov't would be replaced by C
>
> I've looked for formulas, but what I've turned up is multiple values
> to one value e.g. $ or - to blank.
>
> Any help would be appreciated!
> .
>
 | 
Pages: 1
Prev: Help on Custom Task Pane in Excel 2007 using Managed code...
Next: Error can't Find File