| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
change cell contents
Hi,
In various cells across a spreadsheet , I need to replace the contents of the cell with a concatenated text. eg, I have say, '100' in several cells across the sheet, I need to replace it all with 'Days 100'. how can I do that? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
change cell contents
Do a find and Replace (Ctrl + H). Set it for exact matches only. Find 100 and
replace with Days 100 -- HTH... Jim Thomlinson "Mary" wrote: Hi, In various cells across a spreadsheet , I need to replace the contents of the cell with a concatenated text. eg, I have say, '100' in several cells across the sheet, I need to replace it all with 'Days 100'. how can I do that? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
change cell contents
Hi,
sorry I havent being clear to state my need. Actully I found the answer in another thread here. thanks a lot for replying anyway Mary "Jim Thomlinson" wrote: Do a find and Replace (Ctrl + H). Set it for exact matches only. Find 100 and replace with Days 100 -- HTH... Jim Thomlinson "Mary" wrote: Hi, In various cells across a spreadsheet , I need to replace the contents of the cell with a concatenated text. eg, I have say, '100' in several cells across the sheet, I need to replace it all with 'Days 100'. how can I do that? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change cell contents when pull down menu choices change | Excel Worksheet Functions | |||
| How do i change the colour of a cell according to the contents? | Excel Discussion (Misc queries) | |||
| change cell contents to bold | Excel Worksheet Functions | |||
| Please help! Macro to change cell contents based on cell to the left | Excel Programming | |||
| run code after cell contents change | Excel Programming | |||
Linear Mode
