| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Concatenating text cells in a row (No. of cells not fixed)
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concatenating non adjacent cells | Excel Discussion (Misc queries) | |||
| Fill variable number of cells with a fixed text | Excel Programming | |||
| Concatenating Cells | Excel Discussion (Misc queries) | |||
| Moving, deleting, and concatenating text in cells. | Excel Worksheet Functions | |||
| concatenating cells with their formats | Excel Worksheet Functions | |||
Threaded Mode
