Carriage Returns in a Cell - what character?

[lord_yo]

Hi there

I was looking for a way to paste data from Word into Excel, and found several posts on the topic (e.g. http://www.mrexcel.com/forum/showthread.php?t=337939 or http://www.mrexcel.com/forum/showthread.php?t=221306).

However, I didn't find any explanation on what the ASCII character would be for a "soft" carriage return (i.e. the character entered via ALT-Return in Excel). It would be helpful for a search & replace routine.

Any ideas?
LY

 

[Jonmo1]

you can find out the character # with the a combination of the Code and Mid functions.

Say you know the sentence contains a soft return at the 15th character, you would use

=CODE(MID(A1,15,1))

that will tell you the Character number for the soft return..

But I think it's 10

 

[jproffer]

I can't remember either, but if it's not 10 try 13 as well....Chr(13) is a line break in a message box (I think...or 10...one of them, lol)

 

[RoryA]

10 is Line Feed (which is what you want), 13 is carriage return. In VBA (if you are automating the replace), you can use vbLf