Avatar of Ian Bell
Ian Bell
Flag 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
SpreadsheetsMicrosoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Subodh Tiwari (Neeraj)

8/22/2022 - Mon
Daniel Pineault

Still not clear on your data?

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

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
CompProbSolv

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
Subodh Tiwari (Neeraj)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Ian Bell

ASKER
Thanks guys, The last two solutions work best for me.
best regards
Ian
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Subodh Tiwari (Neeraj)

You're welcome Ian! Glad we could help.