Sort funktion

[heinrich3]

Hi
I want to seperate some numbers, but I can't find a solution.
If is in cell A1 the number 10 copy B1 and past it in C1
If is in cell A2 the number 20 or 30 or 40 copy B2 und past it in C2

Tank you for help Heinrich

[shg]

Welcome to the forum, heinrich.

That's more than a little cryptic -- how about an example workbook, and an explanation in context, mein Herr?

[protonLeah]

Using worksheet formulas,

If is in cell A1 the number 10 copy B1 and past it in C1
In C1:

Please Login or Register  to view this content.

If is in cell A2 the number 20 or 30 or 40 copy B2 und past it in C2
In C2"

Please Login or Register  to view this content.

[heinrich3]

Thank you protonLeah, it works!