MrExcel Publishing
Your One Stop for Excel Tips & Solutions

HELP remove 1st space in address list

Posted by Allen on March 22, 2001 8:03 AM

Is there a way to remove the 1st space in an address list. ( I cant use the find and replace because I need the other spaces in the cell ). I have a list of 1500 so a fuction would really be helpful !@!

Thank you

Posted by Allen on March 22, 2001 8:42 AM

I DID IT !@!!@!

I Did it @!@, I used Data, convert to columns, fixed with and made a break line just before the 1st letter of the address and break line very wide to all of the rest of the info !@!

It's fun #@!#