Prev: Count number of people
Next: copy and past cells found by SUMPRODUCT
From: msnyc07 on 29 May 2010 18:23
I have a large spreadhsheet with data I've manually copied/pasted from
various sources including web pages.

As I am trying to do things like import to Mysql or even Trim in Excel I
find there are many spaced between words which aren't recognized as such (I
know this because they don't Trim, and or when doing shift-arrow to jump
between words they ignore that space)

Is there some way/function to search for non-space spaces and replace? Is
there some character set they could belong to? I was/am hoping for some type
of advanced Trim function but am doubtful that is going to be that easy.

Right now when I find a 'bad' record I select the character that seems to be
a space, and do a search replace on it with space, but that could take
forever.
From: Bernard Liengme on 29 May 2010 18:49
In some empty cell type formula =char(160)
This is a non-breaking spaces - it will be invisible
Select and copy that character
Use this in the Find & Replace dialog
best wishes

--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
REMINDER: These newsgroups are about to die. We will all meet again at
http://social.answers.microsoft.com/Forums/en-US/category/officeexcel

"msnyc07" <msnyc07(a)discussions.microsoft.com> wrote in message
news:E871EB8D-30C8-484F-9559-E5106CEFB21F(a)microsoft.com...
> I have a large spreadhsheet with data I've manually copied/pasted from
> various sources including web pages.
>
> As I am trying to do things like import to Mysql or even Trim in Excel I
> find there are many spaced between words which aren't recognized as such
> (I
> know this because they don't Trim, and or when doing shift-arrow to jump
> between words they ignore that space)
>
> Is there some way/function to search for non-space spaces and replace? Is
> there some character set they could belong to? I was/am hoping for some
> type
> of advanced Trim function but am doubtful that is going to be that easy.
>
> Right now when I find a 'bad' record I select the character that seems to
> be
> a space, and do a search replace on it with space, but that could take
> forever.

From: Gord Dibben on 30 May 2010 10:26
Or simply use Alt + 0160 in the replace what dialog.


Gord Dibben MS Excel MVP

On Sat, 29 May 2010 19:49:14 -0300, "Bernard Liengme"
<bliengme(a)TRUENORTH.stfx.ca> wrote:

>In some empty cell type formula =char(160)
>This is a non-breaking spaces - it will be invisible
>Select and copy that character
>Use this in the Find & Replace dialog
>best wishes

From: Bernard Liengme on 31 May 2010 09:06
I had tried that without success so went for the copy route
best wishes
Bernard

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:dat406hjpe3mbku36if9giu2j4pb8ncmm4(a)4ax.com...
> Or simply use Alt + 0160 in the replace what dialog.
>
>
> Gord Dibben MS Excel MVP
>
> On Sat, 29 May 2010 19:49:14 -0300, "Bernard Liengme"
> <bliengme(a)TRUENORTH.stfx.ca> wrote:
>
>>In some empty cell type formula =char(160)
>>This is a non-breaking spaces - it will be invisible
>>Select and copy that character
>>Use this in the Find & Replace dialog
>>best wishes
>
 | 
Pages: 1
Prev: Count number of people
Next: copy and past cells found by SUMPRODUCT