Delete Text from a "Tabbed" Cell

[KGEORGE13]

Hello all,

I've run into a problem with using a VBA to delete certain text from cells. I call it a "Tabbed" cell, because I'm not sure what it actually is called. This is an imported sheet from a different software. As you can see in the picture below, the cell has 3 lines, but the formula bar up top only shows the first. I want to run a macro that will delete all text but the first line of the cell. Anything helps!

thank you!

 

[Fluff]

If you put

=LEFT(B10,FIND(CHAR(10),B10)-1)

into another cell. does it return what you want?

 

[KGEORGE13]

If you put

=LEFT(B10,FIND(CHAR(10),B10)-1)

into another cell. does it return what you want?

Wow, Can't believe I didn't think of that.

Thank you!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[KGEORGE13]

While I have you here, If you could help me with one more thing, that would be great (if not, I will create another thread). This seems simple.

I want to run a macro to delete all rows where the cell in column A starts with "E" or is blank.

 

[Fluff]

A that's a totally different question, it needs a new thread. Thanks