I have spaces following names in my cell, how do I delete them?

I have around 1000 rows with names in each cell. There appears to be extra
spaces following each name. How can I easily delte all these spaces without
backspacing each one?

You can run this macro

http://www.mvps.org/dmcritchie/excel/join.htm#trimall

on how to install macros

http://www.mvps.org/dmcritchie/excel...ll.htm#install

--
Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon




"LostandConfused" <[email protected]> wrote in
message news:[email protected]...
>I have around 1000 rows with names in each cell. There appears to be extra
> spaces following each name. How can I easily delte all these spaces
> without
> backspacing each one?

Try this:

Select your data, next go to Data/Text to columns, select "Fixed width" and
hit "Finish"

HTH
Jean-Guy

"LostandConfused" wrote:

> I have around 1000 rows with names in each cell. There appears to be extra
> spaces following each name. How can I easily delte all these spaces without
> backspacing each one?