removing spaces after semicolons

Hi All,

I have cells in a sheet containing varying numbers of items separated by semicolons. I want to convert these to columns using text to columns.

The trouble is there are spaces after each semicolon, and I don't know how to get rid of them. I believe this may be compounded by the fact that the cells containing varying numbers of items. When I convert to columns I don't want each cell in the new columns to start with spaces. I'm attaching an example of what I mean (sanitized with fast food joint names).

Any help on this is tremendously appreciated.

Thanks!

Select the column and do a CTRL+H...replace all "; " (with a trailing space) with ";" (without a trailing space) and then do your text-to-columns.

HTH

GWB,