Extract data with specific font from cells with content in several lines

[vikassi]

Platform: Windows10

Excel version: MS Excel for 365 Apps (Version 2008)

Please see the attached excel sheet.

I am trying to read data that has font Green. Please note that a cell can have more than one lines and it is possible that only some lines in a cell are Green and other are default Black.

I have a user-defined function (in attached macro sheet) that reads a cell with multiple lines and extract only those lines that has font Green.

But the output comes in one line. Can you please help me to get the output in multiple lines in one cell?

Thanks, Vikas

[jindon]

D2:
=GetColorLines(B2)

Please Login or Register  to view this content.

[vikassi]

Hi jindon,
Thanks for the response!

Your code is doing same what my code is doing.

I need help to understand how I can enter line break in returned values.
So if A and B are marked Green, the output should not be AB, output should be:
A
B

And Both A and B should be in same cell.

thanks, Vikas

[jindon]

Hi jindon,
Thanks for the response!

Your code is doing same what my code is doing.

Are you on Mac?

Then replace all vbLf with vbCr

[vikassi]

it worked now when I clicked on wrap text ..

thanks so much!

[jindon]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.