I have some data that gets pulled in from an import and I'm trying to split the data but I'm running into some confusion
A1
BUF-8(-110)
I need to pull the "BUF" into one cell(b1) and -8 in another (C1)
=Left(A1,3) and it would give me BUF
I ran into a problem when it was 2 characters...