Format Cell Data so text appears in neat format?

[mccrimmon]

I have a spreadsheet of around 600 rows.

In column R is a list of data, which is seperated by a comma.

Example:

Name, Address, Address2, Post Code

I want to create a macro that runs through each cell in column R and formats the data so it appers like this in each cell:

Name,
Address,
Address2,
Post Code

In otherwards, doing exactly what you would do if you were manually pressing Alt and Enter after every comma?

Is this possible?

Thanks

[NBVC]

Select the column and go to Edit|Replace

Replace a space (use spacebar)

with this: Hold the ALT key down and enter 010 with your number pad on the keyboard.

Click Ok,

You might have to Format Cells with Alignment: Wrap text.

[Cutter]

Shouldn't that be: replace a comma space ", "

otherwise you'll be replacing a lot of spaces where you don't want them replaced?

[NBVC]

Yes thanks. You are correct.