Want to concatenate using command

[bhushankshirsagar]

want top competitors which is sorted

and only when there is value in front of the name of the person


e.g


rajvir 2000

mahavir 5000

rupesh 6000

Ajit nil.


if there is value then only it should concatenate if there is no value then it should not


HELP!


THANKS

 

[vasim]

Hello,


=IF(OR(B1=" ",B1="Nil"),A1,A1&B1)


Considering your names are in A1 & amount in B1

 

[Luke M]

Similar to Indian's:

=IF(ISVALUE(B1),A1&" "&B1,A1)