Removing line break - 

[0nyx175]

Hi guys. I have the following header

Tran Dte ---- Source ----- Code Amount Balance Post DteAAdd Info NB

I need a macro to get rid of the annoying line break / square box thing. Can anyone help me?

 

[VoG]

Try selecting the cell and running

Sub test()
ActiveCell.Replace what:=Chr(10), replacement:=" ", lookat:=xlPart
End Sub

 

[0nyx175]

Try selecting the cell and running

Sub test()
ActiveCell.Replace what:=Chr(10), replacement:=" ", lookat:=xlPart
End Sub

Nope, didnt work for some reason.. crazy square symbol thing..

 

[VoG]

Try

Sub test()
ActiveCell.Replace what:=Chr(13), replacement:=" ", lookat:=xlPart
End Sub

 

[0nyx175]

Try

Sub test()
ActiveCell.Replace what:=Chr(13), replacement:=" ", lookat:=xlPart
End Sub

Nope.. i think its an unusual character

 

[VoG]

Can you copy just that character and paste it into an empty cell (say M1).What does

=CODE(M1)

return?

 

[0nyx175]

Can you copy just that character and paste it into an empty cell (say M1).What does

=CODE(M1)

return?

Sorted.. it was 26 so i adapted your code. Thanks for the help!!!