Forum Discussion
Formula with multiple conditions
Hello!! I am not tech savvy and need help creating an Excel formula to lighten my workload. Here is what I want to do: whatever the beginning ticket number sequence is in B2 would populate C2 as cor...
Seems a pretty simple problem if I am understanding the issue. Use the Find function to find the first dash "-" and then use Left function to extra the first sequence of numbers. So the Formula in C2 is:
=Left(B2,Find(B2,"-")-1
)