Learning Microsoft Excel

[lobogotti]

very good! you utilized the MID function without it having been suggested. now let me show you another tool that is a life saver in these situations........

highlight column A

go to Data, go to Text To Columns, select fixed width, then scroll down and create your line breaks after every number....you would then click next, finished or just finished.

this will break up your data and the you can use a CONCATENATE to build it back together with the *'s.

Data, Text To Columns can be an EXTREMELY handy tool when dealing with exported info that isn't cooperative.