Keeping two blank cell after the text “Expire Date:”

[nur2544]

Dear all, I am having data like below in the cell A & B

Please Login or Register  to view this content.

Now I want to keep two blank cell after the text “Expire Date:” onwards

Please Login or Register  to view this content.

[lancer102rus]

need this?

Please Login or Register  to view this content.

[nur2544]

Hi lancer102rus, it works perfectly , thanks for your time..

[nur2544]

Hi lancer102rus, would you please add one more logic so that two blank cell after the text “Expire Date:”
Will be merge [ Range("A5:B6").merge] . not entire cell just two blank cell (cell A & Cell B) will be merge.

Please Login or Register  to view this content.

[lancer102rus]

Please Login or Register  to view this content.

[nur2544]

Hi lancer102rus, Yes it works perfectly , You did very nice job for me . that will help me a lots . thanks for your kind help ..

[lancer102rus]

You are wellcome