I was wondering if there was a way to rid datalists of occurences like these:

Mr A S(Blank Characters)
Mith

As they are actual characters searching for blank spaces and replacing them
with nothing does not work. Any suggestions?

sorry just to clarify its as if blank characters overlap actual letters so
you have to manually hit backspace over a letter to make the space disappear.
hope this makes sense :P

"davids" wrote:

I was wondering if there was a way to rid datalists of occurences like these:

Mr A S(Blank Characters)
Mith

As they are actual characters searching for blank spaces and replacing them
with nothing does not work. Any suggestions?

One thing you can try is Find/Replace. In the find what box, hold down the
Alt key and enter 255 or 0160 (using the number keypad-you should get a
special character that appears to be a space). Don't enter anything in the
replace with box. Replace all. Be sure to back up your data.


"davids" wrote:

sorry just to clarify its as if blank characters overlap actual letters so
you have to manually hit backspace over a letter to make the space disappear.
hope this makes sense :P

"davids" wrote:

I was wondering if there was a way to rid datalists of occurences like these:

Mr A S(Blank Characters)
Mith

As they are actual characters searching for blank spaces and replacing them
with nothing does not work. Any suggestions?

No that didn't work but thanks for the suggestion

"JMB" wrote:

One thing you can try is Find/Replace. In the find what box, hold down the
Alt key and enter 255 or 0160 (using the number keypad-you should get a
special character that appears to be a space). Don't enter anything in the
replace with box. Replace all. Be sure to back up your data.


"davids" wrote:

sorry just to clarify its as if blank characters overlap actual letters so
you have to manually hit backspace over a letter to make the space disappear.
hope this makes sense :P

"davids" wrote:

I was wondering if there was a way to rid datalists of occurences like these:

Mr A S(Blank Characters)
Mith

As they are actual characters searching for blank spaces and replacing them
with nothing does not work. Any suggestions?

Hi Davids,

Instead of using alt + numbers, put a space with space bar and try to
replace. It will work.

Regards,

Jaleel

"davids" wrote:

No that didn't work but thanks for the suggestion

"JMB" wrote:

One thing you can try is Find/Replace. In the find what box, hold down the
Alt key and enter 255 or 0160 (using the number keypad-you should get a
special character that appears to be a space). Don't enter anything in the
replace with box. Replace all. Be sure to back up your data.


"davids" wrote:

sorry just to clarify its as if blank characters overlap actual letters so
you have to manually hit backspace over a letter to make the space disappear.
hope this makes sense :P

"davids" wrote:

I was wondering if there was a way to rid datalists of occurences like these:

Mr A S(Blank Characters)
Mith

As they are actual characters searching for blank spaces and replacing them
with nothing does not work. Any suggestions?

davids wrote:
I was wondering if there was a way to rid datalists of occurences
like these:

Mr A S(Blank Characters)
Mith

As they are actual characters searching for blank spaces and
replacing them with nothing does not work. Any suggestions?

Hi Davids,

try with a combination of TRIM and CLEAN functions...


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

To really see what's in there, download Chip Pearson's CELLVIEW add-in.

http://www.cpearson.com/excel/CellView.htm


Gord Dibben MS Excel MVP

On Tue, 29 Aug 2006 19:02:01 -0700, davids
wrote:

I was wondering if there was a way to rid datalists of occurences like these:

Mr A S(Blank Characters)
Mith

As they are actual characters searching for blank spaces and replacing them
with nothing does not work. Any suggestions?

Gord Dibben MS Excel MVP