Thursday 13 April 2017

Change the case of text in excel file

//// Proper case

formula- =PROPER(ColumnName)




//// Upper case

formula- =UPPER(ColumnName)




//// Lower case

formula- =LOWER(ColumnName)


at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Excel Sort values in ascending order using function TEXTJOIN

 Excel ::  Text ::  1,3,5,2,9,5,11 Result :: 1,2,3,5,5,9,11 Formula ::     TEXTJOIN ( ",",1,SORT(MID(SUBSTITUTE( A1 ,","...