=trim(C4)&trim(D4)&trim(E4)&trim(F4)&trim(G4)
Try the above, assuming the data is in the addresses used.
Thanks, David
On Saturday, December 23, 2017 at 1:39:57 AM UTC-8, Aamir Shahzad wrote:
>
> Friends,
>
> I want to concatenate all below data in one cell without any space.
> Formula please.
As I couldn't got the answer so far so please resolve the attached query.
On Sun, Dec 24, 2017 at 4:57 AM, who wrote:
> Use the Trim function. Thanks, David
>
> On Saturday, December 23, 2017 at 1:39:57 AM UTC-8, Aamir Shahzad wrote:
>>
>> Friends,
>>
>> I want to concatenate all below data in o
