How to Combine text In Excel | Combine Two text In Excel Easy and simple

 How to Combine text In Excel


Here are the steps to combine/concatenate text from two cells


Follow the steps:-

1. Firstly data should be in two columns or cells 

    

For Example- 1.



2. Now in coloum C type the concatenate formula 


3. Select coloum A, "sapce",Coloum B Press enter



4. Boom!!!!!! Here is the magic result


5. Now Drag the formula down 


It's Done!!!!!



Here is the video













Post a Comment

Previous Post Next Post