Left function with IF

[TcT85]

Hi,

Im trying to create a column with left function with certain number of letters/numbers depends on text string.

Data:

1111-1

2222-2

AAAA11

BBBB1122

The result im looking for:

1111

2222

AAAA11

BBBB11

So I only want 4 letters/numbers when there is symbol "-" and only maximum 6  letters/numbers,

How do I set this up?

[JoBI · Accepted solution]

Hello,
You can try something like this:
LEFT(Column, MIN(IFERROR(SEARCH("-",Column),LEN(Column)+1)-1, 6))