Need to get only Levels from userid

[MEDHA07]

Hi All,

I want to get the User Level from the UserField.This Field has the Userid along with LevelType.

UserID

ABCL1    -L1

HZHL2 -L2

HSDL3-L3

JHHJ-NA

GHJD-NA

GHJJ-NA

[lowrycody]

Hello Harish,

Something like this should help you return LevelType, assuming the delimiter is always '-'.

=mid([UserID],index([UserID],'-',1),len([UserID]) - len(index([UserID],'-',1)))