Ian Bell

asked on

# formula to select first letter in name

Hi,

I'd like a formula to select data where first letter in a name = U

example

formula

UABCD 46 =46

ABCD 32 = 0

ACDE 46 = 0

UACDE 50 -50

Many thanks

Ian

I'd like a formula to select data where first letter in a name = U

example

formula

UABCD 46 =46

ABCD 32 = 0

ACDE 46 = 0

UACDE 50 -50

Many thanks

Ian

Assuming A1 hold your text such as 'UABCD 46' then you could do something like

`=VALUE((IF(LEFT(A1,1)="U", RIGHT(A1, LEN(A1)-FIND(" ",A1)),0)))`

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

Thanks guys, The last two solutions work best for me.

best regards

Ian

best regards

Ian

You're welcome Ian! Glad we could help.

Are UABCD 46 in 1 column or 2? Why not post a sample workbook?