I've been trying to come up with a way to sort some data but don't know the formula i'm looking for. Here is the what i'm aiming for...
Say i have the cell: Edison Mission Energy, 7.50%, 06/15/13
Is there a way I can get excel to output everything before the comma, so the result would be "Edison Mission Energy"
I know it sounds basic but it would def help me. Thanks,
Geoff
=LEFT(A1,FIND(",",A1)-1) will do that
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
That will partially work. The only problem with that formula is that it leaves my output as "NA" if the cell has no comma. Is there a way to expand it so that if it doesn't have a comma it displays the orginal cell?
The easy way is to use conditional formatting to mask display of #N/A
Entia non sunt multiplicanda sine necessitate
=if(iserror(find(",",a1)),a1,(left(a1,find(",",a1)-1)))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks