Thread: [Solved] Comparing 2 columns of Text
View Single Post
 
Old 01-30-2012, 08:36 AM
Catalin.B Catalin.B is offline Windows Vista Office 2010 32bit
Expert
  
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default
You want to compare the lenght of text in two cells?
Try : =if(len(C2)>len(C1);len(C2)-len(C1);C2&" lenght is not bigger than "&C1&" lenght.")
Reply With Quote