Forum Discussion
TcT85
Helper III
Helper IIILeft 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...
Hello,
You can try something like this:
LEFT(Column, MIN(IFERROR(SEARCH("-",Column),LEN(Column)+1)-1, 6))
JoBI
Resolver II
Resolver IIHello,
You can try something like this:
LEFT(Column, MIN(IFERROR(SEARCH("-",Column),LEN(Column)+1)-1, 6))