Adding Number

[agonysWeeper]

From my Cell B6 which is containing 041-110801-089 and what is the best formula for my C6 to get the value of B6 then add 001 or look like this 41-110801-89-1.

 

[Giordano Bruno]

Do you want to add 001 or do you want the cell to look like your example. It doesn't seem to be the original with 001 added.

 

[agonysWeeper]

The answer should add 001 but if the suggested formula is looks like my sample above much appreciated.

 

[Giordano Bruno]

I guess my question is - why doesn't the answer look like 041-110801-090?

 

[agonysWeeper]

Cell B6 = 041-110801-089
C6 = should 041-110801-089 and add 001 at the end so, it look like this 041-110801-089-001

 

[Giordano Bruno]

=B6&"-001" Assuming that B6 is text.