If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Remove non-space spaces?
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. |
#2
|
|||
|
|||
Remove non-space spaces?
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/...ry/officeexcel "msnyc07" wrote in message ... 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. |
#3
|
|||
|
|||
Remove non-space spaces?
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" 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 |
#4
|
|||
|
|||
Remove non-space spaces?
I had tried that without success so went for the copy route
best wishes Bernard "Gord Dibben" gorddibbATshawDOTca wrote in message ... 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" 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 |
Thread Tools | |
Display Modes | |
|
|