Search This Blog

Search Engine

Custom Search

20160611

How to connect contents of 3 different columns into one single column by AND Formula?

How to connect contents of 3 different columns into one single column by AND Formula?


If there is content in cells say A1,A2 & A3 then we can put a new formula in A4

A4 = Formula = given here - =A1&"-"&A2&"-"&A3
The resultant in A4 by this formula will be the contents clubbed together in one cell by a - in between them.

Eg.
A1=East
A2=West
A3=Up
Then A4 by this formula will give result East-West-Up (=A1&"-"&A2&"-"&A3)

No comments: