Insert column with text parts from two cells

[CoSinus]

Hello, everyone,
I would like to insert a help column to the right of column A.

Fox.png

This column should take over the cell contents of A and also the contents of column C, unless it is a pure number.
A number that is combined with text or characters does not count and can be used (row 4)

There should be a hyphen between the text from A and the text from B.

In the attached picture you can see the compound inserted column B.
If column C is empty, then the macro should go to the next (D) and take the word or word/character combination and insert it after the hyphen (example row 12).
If column D is also empty, then the macro should find the next described column and if there it takes the word or word-character combination, and so on. (row 20)

If the column C or the next described column contains a pure number and no letter, then nothing should happen (row 19).

I have a formula that can do this but I would like a code.

=TEXTJOIN("-",TRUE,A1,IFERROR(INDEX(C1:K1,MATCH(1,ISTEXT(C1:K1)*(C1:K1<>""),0)),""))

Thanks very much in advance for your help

[Paul]

This should do the trick...

Please Login or Register  to view this content.

[CoSinus]

Thank you very much and sorry for the late reply.

It works fine.
There is still one small flaw.
It adds pure numers.

Row 19 is

Price Willing to Pay-2500

And not

Price Willing to Pay.

Whenever there is only a number in cell C it should jump to the next. When there are no texts oder combined text and numbers it sould not add anything at all.


If the row 19 for example is altered in the way the image shows.
The script produces:
Price Willing to Pay-2500
like in the picture and not

Price Willing to Pay-sef007

The next non pure number cell is filled with
sef007

Thank you very much for the help so far.

[Paul]

It looks like your "pure numbers" are left-aligned, which tells me they are not "pure numbers", but instead are "numbers stored as text". If you change those to "pure numbers" the code should work fine. Alternatively, you can adjust the code to try coercing the cell values to numbers (e.g. add 0 or multiply by 1) and if the result is numeric proceed accordingly.

When I download a copy of your workbook, put my code into it and run it, the 2,500 value does NOT get appended in row 19. If it does in your copy, that needs to be addressed.

[CoSinus]

It works like a charm.
I went with the second option.

Thank you very much.
You are great