![]() |
#1
|
|||
|
|||
![]()
A1 B1
A2 B2 three one two three in A1 cell i need a formula compare B1,A2,B2 in this 3 cell length of which cell is larger come string in A1 |
#2
|
||||
|
||||
![]()
That is pretty basic:
=MAX(LEN(B1),LEN(B2),LEN(A2)) returns the greatest string length and: =IF(LEN(B1)=MAX(LEN(B1),LEN(B2),LEN(A2)),B1,"")&IF (LEN(B2)=MAX(LEN(B1),LEN(B2),LEN(A2)),B2,"")&IF(LE N(A2)=MAX(LEN(B1),LEN(B2),LEN(A2)),A2,"") returns the longest string(s).
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to extract only numbers from a STRING? | Learner7 | Excel | 3 | 07-02-2013 06:25 AM |
String conversion formula? | JGTExcel | Excel | 3 | 02-10-2012 04:39 PM |
Export string from e-mail body to .csv | aphrodita | Outlook | 0 | 01-05-2012 08:53 AM |
![]() |
wineattorney | Outlook | 1 | 03-29-2011 02:15 AM |
Extract from String using Wildcard | whousedmy | Word | 0 | 05-21-2009 01:35 AM |