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
|
|||
|
|||
Spaces not being recognized be excel as spaces!! Help!
I have data imported into excel. One of the columns
contains "machine numbers", but it is a "fixed width" column of 15 characters (comes from the database where I import from). The "machine numbers" are various lengths, so the remaining 15 characters appear to be spaces or blanks - the only problem is that excel doesn't recognize them as spaces...but within a cell I can arrow right or left and select these "spaces" and delete them but none of the formulas or functions work to get rid of them...even using find/replace does not work...any ideas??????? |
#2
|
|||
|
|||
Spaces not being recognized be excel as spaces!! Help!
Try
=IF(ISERROR(--RIGHT(A1)),--SUBSTITUTE(A1,RIGHT(A1),""),A1) -- Regards, Peo Sjoblom "Kevin" wrote in message ... I have data imported into excel. One of the columns contains "machine numbers", but it is a "fixed width" column of 15 characters (comes from the database where I import from). The "machine numbers" are various lengths, so the remaining 15 characters appear to be spaces or blanks - the only problem is that excel doesn't recognize them as spaces...but within a cell I can arrow right or left and select these "spaces" and delete them but none of the formulas or functions work to get rid of them...even using find/replace does not work...any ideas??????? |
#3
|
|||
|
|||
Spaces not being recognized be excel as spaces!! Help!
I tried but it just gives me #VALUE! error! Want me to
email you a sample? This is the most bizarre thing... |
#4
|
|||
|
|||
Spaces not being recognized be excel as spaces!! Help!
If by 'imported" you mean pasted in from a web page, they're probably
CHR(160)s ( 's, or non-breaking spaces, in HTML). You can use David McRitchie's TRIMALL macro to remove them: http://www.mvps.org/dmcritchie/excel/join.htm#trimall In article , "Kevin" wrote: I have data imported into excel. One of the columns contains "machine numbers", but it is a "fixed width" column of 15 characters (comes from the database where I import from). The "machine numbers" are various lengths, so the remaining 15 characters appear to be spaces or blanks - the only problem is that excel doesn't recognize them as spaces...but within a cell I can arrow right or left and select these "spaces" and delete them but none of the formulas or functions work to get rid of them...even using find/replace does not work...any ideas??????? |
#5
|
|||
|
|||
Spaces not being recognized be excel as spaces!! Help!
Awesome, that worked, thanks very much!!!
|
Thread Tools | |
Display Modes | |
|
|