formula help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lee-Anne Waters - 13 May 2005 06:57 GMT

hi,

i need help with a formula please.

i have a list of user names in my table, for example

bills
henryp
lee-annew

what i want to be able to do is drop the last character on each user name
so only the name is given, for example

bill
henry
lee-anne

any ideas much appreciated
thanks
lee-anne

Reply to this Message

Nikos Yannacopoulos - 13 May 2005 07:05 GMT

Lee-Anne,

Assuming the table field is Called UserName, what you need is a formula
Like:

=Left([UserName], Len([UserName]) - 1)

HTH,
Nikos

> hi,
>
[quoted text clipped - 16 lines]
> thanks
> lee-anne

Reply to this Message

Lee-Anne Waters - 13 May 2005 07:17 GMT

you're a legend..

many thanks

Reply to this Message

Nikos Yannacopoulos - 13 May 2005 07:56 GMT

Welcome! No legend here, just happened to be there earlier.

> you're a legend..
>
> many thanks

Reply to this Message