combining two cell

[domvar22]

I have a text in cell b1 and c1 ie b1 (00 no freight) c1 (charge). I need to combine to read no freight charge. Can anyone help me.

[JBeaucaire]

Try:

=B1 & " " & C1

[domvar22]

thanks, almost there, now I have to get rid of the 00

[JBeaucaire]

The problem with 1row questions is the answer may be too simplistic. Are you saying you will always want everything in cell B1 except the first three characters (the 00 and the space)?

If so, try:

=MID(B1,4,50) & " " &C1

Or if the number of characters change and you want everything after the first "space", then use:

=MID(B1,FIND(" ",B1)+1,999) & " " & C1

[domvar22]

It worked, Thanking JBeaucaire.

[zbor]

Please make thread [solved]