Space between the numeric values

[jagadeesh.rt]

Hi,


I need to replace single space in place of comma(,) at once.


A 421,093.00 421,093.00

B 10,197,035.00 9,460,582.00

C 10,197,035.00 9,460,582.00

 

[Faseeh]

jagadeesh.rt,


Welcome to the forums!!


Have you tried Replace menu to replace all spaces with commas??


Regards,

 

[tinojoshi]

hi,

try this

=REPLACE(TEXT(A2,"000,000.00"),FIND(",",TEXT(A2,"000,000.00")),1," ")

you can adjust the format as per your requirements.


Cheers

Chandrashekhar

 

[Kevin@Radstock]

Hi

Find & Replace

Or a function, assuming your data is in A1:A3, in B1 & copy down:

=SUBSTITUTE(A1,","," ")


Kevin

 

[Debraj]

Hi Jagadeesh,


I guess your data is in Numeric and you want display it in ## ##0.00

* change Number Format to above


or


* Go to VBA (Alt F11)

* Go to Immediate Window..

* Write ? Application.ThousandSeparator

It will display your current Thousand separator.

[pre]

Sub ChangeSystemSeparators()

Range("A1").Formula = "1,234,567.89"
MsgBox "The system separators will now change."

' Define separators and apply.
Application.DecimalSeparator = "-"
Application.ThousandsSeparator = "-"
Application.UseSystemSeparators = False
End Sub

[/pre]

**From documentation


If you are searching how to change "," to " " then you dont need help from Excel, you need help from Window..

Control Panel > Region & language > Format > Additional Setting

Set Thousand Separator as " ".


I wish, I am guiding you in wrong direction..


Regards,

Deb