Does any one knows, the substitute command in Excel?

Question

eg: A1 Apple

A2 Orange

A3 Mango

I want to add "Juice" to all by using substitute command in Excel

Thanks

Answer 1

you can put the word Juice in cell B1, B2, B3 and then in cell C1, C2, C3 you can do =concatenate (A1," ",B1) and that should join the two words.... if you don't put the " " in between you won't get a space between the words.

Hope that helps!

Answer 2

in B1

write

=a1+" Juice"

copy this formula to B2:B3