Forumula for address list - Really struggling with this one

[thomasmarc]

Hi Guys,

I'm really struggling to find help to for this

I have a list of addresses I’d like to put in an excel spreadsheet document.

I have very little experience of excel formulas.

I’m trying to have find a formula that is able to re-arrange these in the columns I’ve provided.

Please see sample attached.

Hope someone can help with this.

Kind Regards

Marc Thomas

[foxguy]

It looks to me like you want the list sorted by removing the "WWW." and then sorted.

You can remove the "WWW." by using this formula "=SUBSTITUTE(A15,"www.","")". Then just sort the list.

[jaslake]

Duplicate post? http://www.excelforum.com/excel-prog...el-2000-a.html