Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clear a Carriage Return from a String Value
Excellent!
Thank you, that works perfectly! "Dan E" wrote in message ... This will work on the selected range, clears the cr's lf's crlf's and leaves nothing in their place Sub ClearCRLF() For Each Cell In Selection temp = Cell.Text For i = 1 To Len(temp) a = Mid(temp, i, 1) If a = vbCrLf Or a = vbCr Or a = vbLf Then temp = Left(temp, i - 1) & Right(temp, Len(temp) - i - 1) End If Next Cell.Value = temp Next End Sub Dan E "RC-" wrote in message ... Hi All, I have a string in a cell that has a Carriage Return in it. I'm trying to perform a Vertical Lookup and it's not working because of the CR. How can I programmatically remove the CR from the String(s)? Any help would be great! RC- BTW - I already tried the Trim function that did not work. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Carriage return | Excel Discussion (Misc queries) | |||
Can I insert 'carriage/line returns' in text string? | Excel Worksheet Functions | |||
program carriage return | Excel Discussion (Misc queries) | |||
Carriage Return | Excel Worksheet Functions | |||
Clear a Carriage Return from a String Value | Excel Programming |