Removing blank characters ?

[bvinternet]

Hi, I have a column that contains a reference number.

Some of the records have blank spaces in them or immediately after them, e.g.

(assume " is a blank space)

1234"""
12"3456

Is there an easy way to select the column, remove all blank spaces and to then left-align the result ?

Thanks in advance for your continued help.

Matt

[Bryan Hessey]

Select the column (assuming this is column A, click the A to highlight the whole column), click EDIT, Replace, put a space in the 'find what', and then click 'Replace All'

[KL]

Hi,

select the column
go to menu Edit>Replace
in Find what' box type a space
leave 'Replace with' box empty
press 'Replace All' button

Regards,
KL

"bvinternet" <[email protected]> wrote
in message news:[email protected]...
>
> ::Hi, I have a column that contains a reference number.
>
> Some of the records have blank spaces in them or immediately after
> them, e.g.
>
> (assume \\" is a blank space)
>
> 1234\\"\\"\\"
> 12\\"3456
>
> Is there an easy way to select the column, remove all blank spaces and
> to then left-align the result ?
>
> Thanks in advance for your continued help.
>
> Matt::
>
>
> --
> bvinternet
> ------------------------------------------------------------------------
> bvinternet's Profile:
> http://www.excelforum.com/member.php...o&userid=25525
> View this thread: http://www.excelforum.com/showthread...hreadid=389678
>