Hi,

I request you all to help me solve this problem.

I have an excel file with data in rows like following ;
A B
C D
1 This Is
Sample 2587
2 This Is
547
3 This 257
222
4 This Is
Sample text

Required Result
This is sample
This is
This
This is sample text

Is there a way that I can concatenate only the text cells and ignore
the numeric ones (Per Row).

The number of cells containing text are variable (but they are in
starting only)

I would be grateful for your help.

Regards

Ashish Sharma