| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find & Replace part of cell contents
in Excel 2003 I've an input worksheet with text in some cells
some users formated their text using multiple spaces causing text length problems from another spreadsheet which is proofing the input I can locate the problem cells SrceFld ="D45" Len(SrceBook.Sheets("InputSheet").Range(SrceFld).V alue) I want to replace all cell contents occurances of " " with " " (double space with single space) I've tried didn't change anything Replace SrceBook.Sheets("InputSheet").Range(SrceFld).Value , " ", " ", 1, -1, 1 didn't change anything SrceBook.Sheets("("InputSheet").Range(SrceFld).Rep lace What:=" ", replacement:=" ", Lookat:=xlPart Fails SrceBook.Sheets("Execute Dealer Plan").Range(SrceFld).Value.Replace What:=" ", replacement:=" ", Lookat:=xlPart -- Jim |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find & Replace: find part cell, replace whole cell | Excel Worksheet Functions | |||
| Find & replace different years (part of the date)in a column | Excel Worksheet Functions | |||
| find text in cell and replace it with part of the text in that ce. | Excel Discussion (Misc queries) | |||
| Find and replace part of a text string | Excel Discussion (Misc queries) | |||
| How do I find and replace part of a hyperlink that isn't visible? | Excel Discussion (Misc queries) | |||
Threaded Mode
