one cell with multiple lines od address

[diggad]

Hey Guys!

This is my first post....

I have one cell...

with this in it:


Address line 1
Address line 2
Address line 3
Address line 4
Address line 5

But you can see there are no comma's at the end.

How do I get comma's on the end of them?

Ive tried looking all over the internet - and it's just way too difficult for my liking.

Much appreciated help guys!

Regards,
Dhiren

[dominicb]

Good afternoon diggad

...and welcome to the forum!!

there are no comma's at the end.
How do I get comma's on the end of them?

How about something like this. Short and sweet :

Please Login or Register  to view this content.

HTH

DominicB

[diggad]

dude! THanks!

[diggad]

i might play really dumb here, but how do i specify for a number of cells... i have these addresses in like a1-a30...

[dominicb]

Hi diggad

i might play really dumb here, but how do i specify for a number of cells... i have these addresses in like a1-a30...

Oh yeah, sorry
Just select your range, then use this :

Please Login or Register  to view this content.

HTH

DominicB