What is the most efficient way to combine text from multiple cells into one cell without using the CONCATENATE function?
A) Using the TEXTJOIN function
B) Using the LEFT function
C) Using the SUBSTITUTE function
#excel #msexcel #dataanalyst #dataan
Problems can be solved, Inconvenience is Subjective.
Whenever solving the problem address the inconveniences first and plan on overcoming it this will ensure smoothness