delete unwanted spaces at the end of a cell
delete unwanted spaces at the end of a cell
On Thu, 8 Sep 2005 14:15:03 -0700, "CHARI"
<CHARI@discussions.microsoft.com> wrote:
>delete unwanted spaces at the end of a cell
=Trim(your_cell)
HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
If you don't want to use another column, select the range (cells, columns,
etc.) you want to manipulate, Edit->Replace then type one space into From
field, nothing into To field and click All.
Stefi
„Richard Buttrey” ezt *rta:
> On Thu, 8 Sep 2005 14:15:03 -0700, "CHARI"
> <CHARI@discussions.microsoft.com> wrote:
>
> >delete unwanted spaces at the end of a cell
>
> =Trim(your_cell)
>
> HTH
>
> __
> Richard Buttrey
> Grappenhall, Cheshire, UK
> __________________________
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks