Objective : To be able to join Text data in Excel cell.
Have you encountered a task in excel where you need to connect the data content of A1,B1,C1 & D1 as shown in the picture. Well it is easy if it is only 1 or two but what if you have a thousand of same task to do?. You just have to use the below formula :
=A1&” “&B1&” “&C1&” “&D1&”” ( Resulting data = The quick brown fox )
The space in between two quotation marks signifies the space of its resulting data. If you put anything in between the two quotation marks it will show up. See below example :
=A1&”-“&B1&”-“&C1&”-“&D1&”” ( Resulting data = The-quick-brown-fox )
and if you are going to do this in repetitive task , Make the formula in Cell E1 and then copy. Hope this helps.