Hello everyone


I am a beginner in Excel, please don't stone me, I would very much like to include this formula for my document.
The task is "simple", but it won't work.

=WENN(H8="99*"&A8&&ZEICHEN(10)&;"Switch "&N8&&ZEICHEN(10)&", Port "&O8&""

My view of the formula:The data is merged from the following fields into one field with a respective line break.
This data is taken from the fields A8 N8 and O8. However, the data is only compiled if there is a number in field
H8 that starts with 99.


When I use this example, the data is compiled, but it is not checked whether this initial 99 number is present.
And everything is written down in one line, but I would like to have a line break.


=WENN(H8="99"&A8&", Switch "&N8&", Port "&O8&""


Wenn ich diese Formel erstelle, kommt "FALSCH"
=WENN(H8="99*"&A8&&ZEICHEN(10)&;"Switch "&N8&&ZEICHEN(10)&", Port "&O8&""

I would be very grateful for your support. Thank you very much!

Please post a sample sheet ( no pics please). Thx

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

please see line Q8

after every ", " i need a new line.

!thank you for watching this

Attached Files

Bezeichnungen - Kopie.xlsx (19.2 KB, 3 views)

Something like ( don't forget to change the formatting of the cells to "wrap text")

Attached Files

Bezeichnungen - Kopie.xlsx (19.4 KB, 1 views)

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thanks meny time, yes that's exactly how I need this.

please you know, any good online course, so that i can learn more about excel.

Thank you where mutch

You're welcome.
I don't know about online courses as users' interests can be very diverse. e.g. I know nothing of VBA or financial functions, but have some experience with other functions and PQ.
I always encourage new learners to participate in XL forums (answering threads and learning from other users); there are very good ones out there where there is lots of activity. The present one has more MsWord activity than XL AFAIK.

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post