All in one column?

Select that column
Data|Text to columns
Fixed width
remove any lines that excel guessed

Finish up.

Steven wrote:

How do I trim the just the leading and trailing spaces in a cell?
For example

" Project - 1234 " becomes "Project - 1234"

Thank you for you help.

Steven

--

Dave Peterson