Hey guys,
i have part numbers that look like this:
1283-104-10T
1283-104-7
1316-2147-6
1316-2147-7T
i need a function that will turn that into
1283-104
1283-104
1316-2147
1316-2147
Currently using
=IF(A3<>"",LEFT(A3,FIND("-",A3)+4),"")
BUT some of the part numbers have 3 in the middle and some have 4
all help would be greatly appreciated!
Bookmarks