VBA to replace in-cell CR/LF characters with spaces?

[itm]

I'm a novice with Excel macros, but am looking for a code sample which will examine a column of cells in a CSV file and replace all in-cell CR/LF characters with space characters.

The file in question is created by exporting values from database. One of the exported columns frequently contains Hex 0d0a characters within the text, and these need to be replaced with spaces.

TIA for any guidance

 

[pman]

Use Replace() and look for Chr(13) and Chr(10)

 

[Mohammad Basem]

Further to what pman has mentioned.

Select the column and run this statement from VBE Immediate window. You may put this line in a macro.

[FONT="Consolas"][SIZE="2"][COLOR="Navy"]Selection.Replace What:=Chr(13), Replacement:=" "[/COLOR][/SIZE][/FONT]

 

[itm]

Thanks - that's perfect

 

[Mohammad Basem]

Thank you for the feedback!