and # formula how its work ?

[sa.1985]

Dear Sir,


I want to know that , why we are using "&" and "#" (this format) in formula ?


how its work ?

 

[dan_l]

To what are you referring?

 

[sa.1985]

I have no any referring but i want to know that , when we are using this "&" in formula ?


you can explain with any formula test but please explain such as i can understand that why we are using "&" ?

 

[dan_l]

In many cases, it's to join to bits of text together.


So:

="peas" & "carrots"

would be "peascarrots"


="peas " & "carrots"

would be "peas carrots"

 

[oldchippy]

Hi,


An alternative is the Concatenate function, but it's so much easier to use the "&"


http://chandoo.org/excel-formulas/concatenate.html

 

[JMe81]

Along these lines, I have text cells that I want merged but with an additional space. When I try the above ="E10 " & "E11", it simply shows up as E10 E11. How can I either merge or concatenate the cells with an additional space (yes I realize it's probably very simple and I'm a twit for not knowing)

 

[SirJB7]

Hi, JMe81!


Tried this?

=E10&" "&E11


Regards!

 

[Hui]

JMe81


Firstly, Welcome to the Chandoo.org forums.


The Double Quote marks around the E10 and E11 convert them from References to Text


So

="E10" & "E11"

appends the two text strings together and you get E10E11


Where as [code]=E10 & " " & E11

appends the two values from cells E10 and E11 together and puts a space in between

E10: "Hello"

E11: JMe81

=E10 & " " & E11[/code] displays Hello JMe81