Hi
I am tyring to use a Mid function to obtain a consultants name from a field, but sometimes the payroll numbers is 5 digits not 6 and i then lose the first letter of the staff members names.
I can't use the Right function as the length of the consultants name always changes.
Any suggestions would be great?
The details are below (in field I6)
s12345 - Jeff Thompson
s68434 - Gary Drest
s9845 - Michelle Frankston
Formula is currently:
=MID(I6,10,30)
This returns "Jeff Thompson" & "Gary Drest" where the payroll is 6 digits, but for the last one it is coming back as "ichelle Frankston"
Any thougths ?
I am tyring to use a Mid function to obtain a consultants name from a field, but sometimes the payroll numbers is 5 digits not 6 and i then lose the first letter of the staff members names.
I can't use the Right function as the length of the consultants name always changes.
Any suggestions would be great?
The details are below (in field I6)
s12345 - Jeff Thompson
s68434 - Gary Drest
s9845 - Michelle Frankston
Formula is currently:
=MID(I6,10,30)
This returns "Jeff Thompson" & "Gary Drest" where the payroll is 6 digits, but for the last one it is coming back as "ichelle Frankston"
Any thougths ?