Extrra spacing after last character

[umeshbanga]

Hi,

I want to add extra spacing (one blank line space) should be created after the text. This would allow clean visual effect before the start of the new row.

Is it possible?

[FDibbins]

I would advice against adding any extra spaces at the start or end of text, as could cause problems later if you need to use formulas referencing those cells.

Not sure what you mean by "This would allow clean visual effect before the start of the new row." though?

[Alf]

This macro will add a blank space after a text, which may or may not be what you asked / wished for.

Please Login or Register  to view this content.

Alf

[berlan]

Hi, if you mean an extra blank line, then try this where the code will run through each textvalue in column A:

Please Login or Register  to view this content.

Kind regards,
berlan