Link to home
Start Free TrialLog in
Avatar of Ian Bell
Ian BellFlag for United Kingdom of Great Britain and Northern Ireland

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
Avatar of Daniel Pineault
Daniel Pineault

Still not clear on your data?

Are UABCD 46 in 1 column or 2?  Why not post a sample workbook?
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)))

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of CompProbSolv
CompProbSolv
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Ian Bell

ASKER

Thanks guys, The last two solutions work best for me.
best regards
Ian
You're welcome Ian! Glad we could help.