Advance Excel || 6) Concatenate Function in MS Excel
Example-1
Title | First Name | Middle Name | Last Name | Full Name |
Dr. | John | A. | Jacob | ? |
Mr. | Nathan | F. | James | ? |
Mr. | Adrian | B. | Anderson | ? |
Mr. | Gerard | G. | Jacob | ? |
Dr. | Zacharias | C. | Charlie | ? |
Dr. | Arne | H. | Thomas | ? |
Mr. | Fexlix | D. | William | ? |
Mr. | Isaac | I. | Noah | ? |
Mr. | Kane | E. | Ethan | ? |
Dr. | Joshua | J. | Joseph | ? |
Example-2
Text1 | Text2 | Formula |
Black | White | ? |
Tea | Coffee | ? |
Month | 25-12-2020 | ? |
James | Thomas | ? |
.





Comments
Post a Comment