Using Left, Mid and Right Functions

J

jaznit

Joined
Feb 8, 2010
Messages
4
Reaction score
0
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 ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

combining countif and mid or right functions 5
right, mid, left functions?? 4
Left,Mid and right function 10
MID function from right to left 3
Formatting part number help 5
Update query to format part numbers 3
Formating part numbers after import from Excel 4
Part number formatting help 1

Top