Forum Discussion
Solved
Left function with IF
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?
Hello,
You can try something like this:
LEFT(Column, MIN(IFERROR(SEARCH("-",Column),LEN(Column)+1)-1, 6))
1 Reply
Hello,
You can try something like this:
LEFT(Column, MIN(IFERROR(SEARCH("-",Column),LEN(Column)+1)-1, 6))