MrExcel Publishing
Your One Stop for Excel Tips & Solutions

replacing characters in excel


Posted by roger worsley on June 21, 2001 1:24 AM

Hi. How can i replace end of line characters in ecel i tab delimiters or ascii.

Thanks


Posted by Joe Was on June 23, 2001 6:52 AM

=SUBSTITUTE(Range,"the Chr to replace","what to put in its place")

This will replace your old "Text" or Value.
You can build a copy sheet and populate it with the above formula, where Range is the cell address you want to edit. Or you can automate it as part of a Macro. JSW