How to find the cell with note and put them all into 1 cell with differnce line

[tuongtu3]

Hi,
I'm looking for help how to find the notes then put them together into 1 cell in difference line.

Regards,
tt3

[prashantha]

Hi

sorry to say your sample sheet does not give a clear pic on what you want to do.
Hope you can do this using VLOOKUP & CONCATENATE functions.

if you can post a sample sheet with little more clarification on it, it would be help to sort out this urgently.

[jindon]

try

Please Login or Register  to view this content.

[nilem]

as an option, UDF

Please Login or Register  to view this content.

[tuongtu3]

Please Login or Register  to view this content.

Hi Prashantha
Thank you for the reply and I will try to be more clear.

@Jindon
Thank you very much for the help. I have been able to get the 3 stars (***) at the beginning of each text line but cannot figure out how to put them at the end of each text line. Can you please help? Thank you.

@nilem
Thank you for your help. Can you teach me how to use your function?

[jindon]

Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[tuongtu3]

Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Hi Jindon,
The new code is perfect and thank you very much for your help. When I transfer to another sheet then all text merge together so how can i break them from ***Honda01: PartXXX******Honda01: PartYYY to

***Honda01: PartXXX***
***Honda02: PartYYY***

Regards,
tt3

[jindon]

Sorry, but I don't understand what you are asking.

Can you upload the file again?

[tuongtu3]

Sorry, but I don't understand what you are asking.

Can you upload the file again?

Hi Jindon,
Please look at cell X13 in the file. and one thing is I want cell "U14" is empty if there's no notes in column "U:U" because I see note "***Car: Remark/Notes***" in cell U14 instead it shoud be empty.

Regards,
tt3

[jindon]

Change to

Please Login or Register  to view this content.

[tuongtu3]

Change to

Please Login or Register  to view this content.

Hi jindon,
The above code is work perfect as I expected. Thank you very much for your time and help.

Best regards,
tt3