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" <LostandConfused@discussions.microsoft.com> wrote in
message news:2B7A5AD7-7CB5-4B12-86C0-D130159055DA@microsoft.com...
>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?