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...
=Left(B2,Find(B2,"-")-1)
Thank you for responding!! I copied that formula and put into C2 and nothing happened when I input ticket numbers. Any advice?
If Ticket# parts always have the same length you may simply use in C2
=LEFT( B2, 6 )and drag it down.
If formula not recalculate the value please check if you are in automatic mode
