Line Feed in Formula Bar

S

Stratuser

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

Insert Pagebreak in Word document 2
Vertical short line in front of word 0
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
Adding comment text - linefeed visible - why? 2
Challenge - Excel Line Feed Character CHR(10) - How to Delete and keep the text formatting without g 7
Overlay line graph points on bar graph 1
Excel Line Feed Character - How to delete the CHR(10) and keep the formatting without going to singl 7

Top