concatenate
=CONCATENATE(B2, " ", A2, "lives in ", C2, ".")
trim: makes multiple spaces to only one space
proper
=PROPER("HELLO World")
output:
Hello World
upper/ lower: makes all letters upper/lower letters
=lower("HELLO WORLD"_
output:
hello world
=upper("heLlo WorLD")
output:
HELLO WORLD
Film108 is one of the best movie promotion and marketing agency in Mumbai, always trying to adapt to innovative approaches for each brand and mark a difference in the digital world.
ReplyDelete