Removing blank characters ?
 

::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

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'


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=389678

Hi,

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

Regards,
KL

"bvinternet" wrote
in message ...

::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