number

[workshop]

cell A1 is 00001
cell B1 is c
in cell c1 I enter: =b1&a1 then result is c1, is there a way that can give me a result as C00001
Thanks

 

[kshanes]

Workshop,

Try this formula in cell c1:

=CONCATENATE(B1,CONCATENATE("0000",A1))

Hope this accomplishes what you were trying to do.

Thanks
Kevin

 

[Hasit]

workshop, actually, your original formula =b1&a1 should give you the result you want. The only thing I would ask is how you have the cell formatted in A1.

If you want it set to general, then in A1, type in '00001 (single quote) and you should get what you need in C1 with the above formula.

 

[beniez]

If you don't want to put your numbers in as text, then use

=B1&TEXT(A1,"0000#&quot

This works for all numbers - eg A1=45, C1='C00045', etc: TEXT() just works like setting the format of a number.

HTH

Ben