Line Feed in Formula Bar

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Challenge - Excel Line Feed Character CHR(10) - How to Delete and keep the text formatting without g 6
Formula appearing as Value in Formula Bar 1
Need to insert line-feed in Excel concatenation (VB) 6
Split data in field on character return 0
Cell formatting shows in formula bar but not in cell 2
Cell formatting in formula bar but not in cell 1
how to insert CRLF (carrage return/line feed) in report 8
Challenge - Excel Line Feed Character CHR(10) - How to Delete and keep the text formatting without g 7

Top