Mid Function question 1

[istone]

Hi,
I am stuck...
I am trying to get the first initial of the first name and the first letter of the last name (after the space) and combine them with :sh
Here is what I did:

Initials: IIf([Team Leader]="Michael Conaghan","MO:sh",Left([Team Leader],1) & "" & Mid([Team Leader],1,1) & ":" & "sh")

Team Leader Result
John Monna JM:sh

I can't get the M to work..what I am missing. Thanks in advance

 

[AlexCuse]

YOu need to use InStr() to get the location of the space, and add 1 to this to get starting position of last name.

Something like this (typed, untested)

Initials: IIf([Team Leader]="Michael Conaghan","MO:sh",Left([Team Leader],1) & "" & Mid([Team Leader],InStr([Team Leader], ' ') + 1,1) & ":" & "sh")

Hope it helps,

Alex

[small]----signature below----[/small]
I don't do any programming whatsoever

Ignorance of certain subjects is a great part of wisdom

 

[istone]

Perfect, thank you so much.