Split And Join Substitute And Perform Surgery On Text Strings

1 minute read Example: =LOWER(“hello”) Result: hello Convert text to upper case Example: =UPPER(D3) Result: JAMES Convert text to proper case (each word’s first letter capitalized) Example: =PROPER(“this is a long sentence”) Result: This Is A Long Sentence Combine different text values to one text Example: =CONCATENATE(A3, ” and “, A4) Result: 30 and 25 … Read more