Programming to delet padded spaces

I have a list of names copied from another program. This field in the other program is padded to 30 spaces. When you copy and past it into excel the full field is transfered, including the spaces on the end of the name that are blank. I'd like to write a function that would get rid of the extra spaces for aesthetics. Does anyone have any suggestions?

Hi

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

Look here for a formula way
http://www.rondebruin.nl/clean.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"alitch" <[email protected]> wrote in message
news:[email protected]...
>
> I have a list of names copied from another program. This field in the
> other program is padded to 30 spaces. When you copy and past it into
> excel the full field is transfered, including the spaces on the end of
> the name that are blank. I'd like to write a function that would get
> rid of the extra spaces for aesthetics. Does anyone have any
> suggestions?
>
>
> --
> alitch
> ------------------------------------------------------------------------
> alitch's Profile: http://www.excelforum.com/member.php...o&userid=24535
> View this thread: http://www.excelforum.com/showthread...hreadid=381270
>

for each cell in selection
cell.Value = Application.Trim(cell.Value)
Next

--
Regards,
Tom Ogilvy


"alitch" <[email protected]> wrote in
message news:[email protected]...
>
> I have a list of names copied from another program. This field in the
> other program is padded to 30 spaces. When you copy and past it into
> excel the full field is transfered, including the spaces on the end of
> the name that are blank. I'd like to write a function that would get
> rid of the extra spaces for aesthetics. Does anyone have any
> suggestions?
>
>
> --
> alitch
> ------------------------------------------------------------------------
> alitch's Profile:
http://www.excelforum.com/member.php...o&userid=24535
> View this thread: http://www.excelforum.com/showthread...hreadid=381270
>

The TRIM function is available in both the worksheet and VBA. It trims both
leading and trailing spaces.
--
Gary's Student


"alitch" wrote:

>
> I have a list of names copied from another program. This field in the
> other program is padded to 30 spaces. When you copy and past it into
> excel the full field is transfered, including the spaces on the end of
> the name that are blank. I'd like to write a function that would get
> rid of the extra spaces for aesthetics. Does anyone have any
> suggestions?
>
>
> --
> alitch
> ------------------------------------------------------------------------
> alitch's Profile: http://www.excelforum.com/member.php...o&userid=24535
> View this thread: http://www.excelforum.com/showthread...hreadid=381270
>
>

Excellent

Thanks Tom.....

alitch