CONCATENATE all values in row without numbers in front

Hi,
I want to concatenate all values in one row the following way:

• All letters will be taken from the first letter onwards, no matter what comes after.
• Numbers only before the letters are to be ignored not after the letter.
• Column B should always be linked no matter what is in there.
• The formula should consider all cells with content in the row
• A number without any text is to be ignored completey, except it is Column B
• cells with only one character - no matter if number or letter or other character - should always be ignored

In the illustration you can see a finished example in column A.
I have inserted the corresponding table.

Link.png

Thanks for your help.

What's the maximum number of values in any one row, an d the maximum number of rows?
This may well determine whether to use Excel standard functions, or a UDF or macro

So does this mean your second rule
"Numbers only before the letters are to be ignored not after the letter."

Should be

Numbers only, OR numbers before the letters but not after the letter, are to be ignored.

...and what's the answer to #3?

Writing a formula to handle 50 columns would be impractical.

There's no reason why 500 rows would 'kill' VBA, even without using a VBA array.

If you're happy to use VBA then let us know.

A VBA is also fine I am grateful for everything.

I forgot to mention that cells with only one character - no matter if number or letter or other character - should always be ignored.

Thanks for your support.