Thanks a lot for coming forward to help Mitja... I came to learn about new
Functions but that is not really what I wanted...

I will elaborate my question for you...

Say I have columns like

A B C

1 4 6
2 3 4
3 2
1

Now I want to bring them all under a Single Column D by using a function
where multiple Columns are copied to a single Column eliminating Blanks

A B C D

1 4 6 1 {From Column A}
2 3 4 2
3 2 3
1 4 {From Column B}
3
2
1
6 {From Column C}
4

I apologise if i was being very vague the last time. Thanks in Advance!!!

Sriram

" wrote:

On May 4, 10:55 am, Sriram wrote:
I want to know whether we can copy multiple columns, and paste them into a
Single column, where all the copied values appear one below the other/
eliminating the Blanks...

Example:
A1 = "All we need"
B1 = "is love"

C1 = concatenate ( SUBSTITUTE(A1;" ";"") ; SUBSTITUTE(B1;" ";"") )

OK? Check Helop on TRIM, CLEAN, SUBSTITUTE functions.
Mitja

PS: You might need to change ; to , depending on regional settings.