Trim function

[wossenhh]

Hi,

Can anybody help me how to use trim function? The data looks like below:

Department
115 - AMC
220 - BMC
331 - LAN

And the intended results should be with out the numbers and -

AMC

BMC

LAN

Thanks,

Wossen

[MarcoWedel]

thanks, now it's answered indeed ...

... although the message you marked as correct does not contain the answer ...