CONCATENATE Is not working properly

[HaroonSid]

hi,
i am trying to join three cell using concatenate

Please Login or Register  to view this content.

but cell m13 and n13 value is not showing,

need help

thanx alot

[queuesef]

Please describe you problem in words....(Explain your logic). Because from what I'm guessing the logic is: if the cells L through N ALL doNot equal "Haroon" then Concatenate - otherwise "Haroon". I believe if you 'layout' your issue you will see it much more clearly.

[davesexcel]

Possibly

Please Login or Register  to view this content.

[Declamatory]

What 3 values are in L13, M13 and N13. What do you expect the value to be? I'm guessing at what you want but you could try:

Please Login or Register  to view this content.

[HaroonSid]

Thanx for the reply'

Cell L13, M13 AND N13 Have a big formula of Concatenate
actually this one is a one formula, because my formula crossed text limit so i divided my formula in 3 cell ( L13, M13 AND N13 )

now i want to join these 3 cell into one,

but i want to add a comma "," in between three cell

[Declamatory]

If HaroonSID is in the cell do you want it to Show appear as part of the end result.

So for example

L13 = Dog
M13 = HaroonSID
N13 = Cat

Do you want answer as Dog,Cat
or
Dog,HaroonSID,Cat
or
Dog,HaroonSIDCat

[queuesef]

You can also use "&" when concatenating cells....like =+L13&","&M13&","&N13.... sometimes it is easier too