help to remove space before the data

[Ricky Martin]

I have a problem, how to remove the spaces before and after the figur
number.
two days I've searched but have not found the answer.

thank you

rick

+-------------------------------------------------------------------
|Filename: Pro.JPG
|Download: http://www.excelbanter.com/attachment.php?attachmentid=769
+-------------------------------------------------------------------

 

[Maurizio Borrelli]

Il giorno giovedì 21 febbraio 2013 20:53:47 UTC+1, Ricky Martin ha scritto:

how to remove the spaces before and after the figure number.
+-------------------------------------------------------------------+
|Filename: Pro.JPG |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=769|
+-------------------------------------------------------------------+

Hi Ricky,
try:
1. Select range
2. Data > Text to Columns
3. (.) Delimited [Next]
4. [v] Space [Next]
5. (.) Do not import column (skip) [Finish]

 

[Kevin@Radstock]

Hi

Formula approach for a couple of unwanted characters.
1: =TRIM(A1)
2: =TRIM(SUBSTITUTE(A1,CHAR(160),""))
3: =SUBSTITUTE(SUBSTITUTE(A1,CHAR(32),""),CHAR(160),"")

Kevin

I have a problem, how to remove the spaces before and after the figur
number.
two days I've searched but have not found the answer.

thank you

rick

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[Ricky Martin]

Il giorno giovedì 21 febbraio 2013 20:53:47 UTC+1, Ricky Martin h
scritto:-

how to remove the spaces before and after the figure number.
+-------------------------------------------------------------------+
|Filename: Pro.JPG |
|Download

http://www.excelbanter.com/attachment.php?attachmentid=769|

+-------------------------------------------------------------------+-

Hi Ricky,
try:
1. Select range
2. Data > Text to Columns
3. (.) Delimited [Next]
4. [v] Space [Next]
5. (.) Do not import column (skip) [Finish]

Hi

Formula approach for a couple of unwanted characters.
1: =TRIM(A1)
2: =TRIM(SUBSTITUTE(A1,CHAR(160),""))
3: =SUBSTITUTE(SUBSTITUTE(A1,CHAR(32),""),CHAR(160),"")

Kevin

thanks to all of you guys, but honestly i dont know why it doesnt wor


im upload my file, hope you can slove this thing

if you slove it, please let me know what happen to my data.

HTTP://WWW.4SHARED.COM/OFFICE/KDDPH0FW/PROBLEM.HTM

thanks a lo

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[Claus Busch]

Hi Ricky,

Am Fri, 22 Feb 2013 10:46:52 +0000 schrieb Ricky Martin:

if you slove it, please let me know what happen to my data.

HTTP://WWW.4SHARED.COM/OFFICE/KDDPH0FW/PROBLEM.HTML

the posted link is not valid

Select your column D => Data => TextToColumns => Fixed width => Finish


Regards
Claus Busch

 

[Maurizio Borrelli]

Hi Ricky,
if =CODE(A1) result 160 try:
1. Select range
2. Data > Text to Columns
3. (.) Delimited [Next]
4. [v] Other [ALT+0160(Tn)] [Next]
5. (.) Do not import column (skip) [Finish]

 

[Maurizio Borrelli]

Il giorno venerdì 22 febbraio 2013 15:14:17 UTC+1, Maurizio Borrelli ha scritto:

4. [v] Other [ALT+0160(Tn)] [Next]

Ops!

4. [v] Other [ALT+0160(Num)] [Next]

Num=Numeric Keypad

 

[Mazzaropi]

I have a problem, how to remove the spaces before and after the figur
number.
two days I've searched but have not found the answer.
thank you
ricky

RICKY[/B], TRY TO DO THIS:

*B1 *--> MID(A1,2,4

Copy down to the other cells.
Please, tell me if it worked for you

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[Ricky Martin]

Hi Ricky,

Am Fri, 22 Feb 2013 10:46:52 +0000 schrieb Ricky Martin:
-

the posted link is not valid

Select your column D => Data => TextToColumns => Fixed width => Finish


Regards
Claus Busch

Hi Ricky,
if =CODE(A1) result 160 try:
1. Select range
2. Data > Text to Columns
3. (.) Delimited [Next]
4. [v] Other [ALT+0160(Tn)] [Next]
5. (.) Do not import column (skip) [Finish]

--
Ciao!
Maurizio

Il giorno venerdì 22 febbraio 2013 08:34:44 UTC+1, Maurizio Borrelli h
scritto:-

Il giorno giovedì 21 febbraio 2013 20:53:47 UTC+1, Ricky Martin h scritto:-
+-------------------------------------------------------------------+ http://www.excelbanter.com/attachment.php?attachmentid=769|

+-------------------------------------------------------------------+--

Il giorno venerdì 22 febbraio 2013 15:14:17 UTC+1, Maurizio Borrelli h
scritto:-

4. [v] Other [ALT+0160(Tn)] [Next]-

Ops!

4. [v] Other [ALT+0160(Num)] [Next]

Num=Numeric Keypad

RICKY[/B], TRY TO DO THIS:

*B1 *--> MID(A1,2,4

Copy down to the other cells.
Please, tell me if it worked for you.

many don't work, i dont know what happen but now i have 2 problem

and i upload it www.mediafire.com/view/?ecc71y94v1zihdw

hope it work, honestly im tired of this, but i must finish this
i dont know what to say but, i know you guys can help me

thank you very muc

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[Claus Busch]

Hi Ricky,

Am Sat, 23 Feb 2013 10:04:31 +0000 schrieb Ricky Martin:

many don't work, i dont know what happen but now i have 2 problem

and i upload it www.mediafire.com/view/?ecc71y94v1zihdw

try:
Find & Select => Replace => Find what: Alt+0160 => Replace with: nothing
=> Replace All
or do it with VBA:

Sub RemoveSpaces()
Dim LRow As Long
Dim rngC As Range

LRow = Cells(Rows.Count, 1).End(xlUp).Row
With Range("A1:B" & LRow)
.HorizontalAlignment = xlGeneral
.VerticalAlignment = xlBottom
.Orientation = 0
End With

For Each rngC In Range("A1:B" & LRow)
rngC = Replace(rngC, Chr(160), "")
Next
End Sub


Regards
Claus Busch

 

[Ricky Martin]

RICKY[/B], GOOD MORNING.

IF NOW DO YOU WANT TO REMOVE ALL SPACES IN BOTH COLUMNS TRY THIS ONE:

*C1 *--> *=VALUE(SUBSTITUTE(A1,CHAR(160),\"\")
D1 *--> *=SUBSTITUTE(B1,CHAR(160),"")*

Please, tell us if it worked for you now.

im really sorry but its not working too, and i dont know why :

+-------------------------------------------------------------------
|Filename: xxx.JPG
|Download: http://www.excelbanter.com/attachment.php?attachmentid=773
+-------------------------------------------------------------------