Replacing line breaks within cells

[anxoperez]

I need to replace all the breaks within cells with the forward slash symbol

/

I have tried to do a find and replace by pasting the break symbol but that does not work (I remember doing that in Word a few years back and it used to work).

I need to do this substitution in Column AG and AH.

If someone can help.

 

[frolicols]

I think the problem is the Chr(10).

I have a MAC and I believe that does not work. This is what we were talking about in the previous threads.

Am I wrong?

If my formula using both char 10 and 13 didn't work, then that vba code wouldn't either.

Unless you can provide an excel file with some sample text, you are going to struggle to get an answer. Post a sample file for us to look at.

 

[CharlesChuckieCharles]

Try it with chr(13)

 

[CharlesChuckieCharles]

According to others 13 should work

"P.S. I discovered that some common Mac VBA constants are not as expected:
vbCr 13
vbCrLf 13
vbFormFeed 12
vbLf 13
vbNewLine 13
vbNullChar 0
vbObjectError 45
vbTab 9
 
"

 

[mb4eb]

Thanks for this, i have needed it so many times!!