Macro to cut the 3 rows text in to a single row

[rajkumarmp]

Hi Champs,

I have attached a file which has input and output tab.
The Input tab has data where a text of a specific row is split-ted across 2 or more than 2 rows.

I need a macro for data to be exact as in Output tab. Thanks in Advance.

[tehneXus]

Hi,

try: text2.xls

contains:

Please Login or Register  to view this content.

[rajkumarmp]

Hi Boss,

Its working fine. Thanks a lot.