Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Line Feed in Formula Bar
I'm having a problem dealing with an imported file that contains strings that
have a some kind of line feed in the formula bar. For example, the words "ADR Ticker" appear on two different lines inside the formula bar, apparently with a line feed between them, and unless I manually go into the formula bar and eliminate the line feed, the string in the cell does not equal "ADR Ticker" without a line feed. I tried inserting Chr(13) into my string formula in VBA, as shown below, but it didn't work: If Trim(Range("F3").Value) < "ADR " & Chr(13) & "Ticker" Then ....do something Any ideas will be appreciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Line Feed in Formula Bar
Try Chr(10)
-- --- HTH Bob (change the xxxx to gmail if mailing direct) "Stratuser" wrote in message ... I'm having a problem dealing with an imported file that contains strings that have a some kind of line feed in the formula bar. For example, the words "ADR Ticker" appear on two different lines inside the formula bar, apparently with a line feed between them, and unless I manually go into the formula bar and eliminate the line feed, the string in the cell does not equal "ADR Ticker" without a line feed. I tried inserting Chr(13) into my string formula in VBA, as shown below, but it didn't work: If Trim(Range("F3").Value) < "ADR " & Chr(13) & "Ticker" Then ...do something Any ideas will be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Line Feed in Formula Adds Double Quotes? | Excel Worksheet Functions | |||
Challenge - Excel Line Feed Character CHR(10) - How to Delete and keep the text formatting without going ro single line in a cell ? | Excel Worksheet Functions | |||
How do I insert a line feed in a formula? | Excel Worksheet Functions | |||
Line Feed | Excel Programming | |||
how does excel store new line and line feed characters? | Excel Programming |