To remove the space between text
=SUBSTITUTE(B1," ","")
To remove the specific number of digit
=LEFT(A2, LEN(A2)-2)
Removes last two characters from contents of A2 (Vitamin)
=RIGHT(A3, LEN(A3)-8) Removes first 8 characters from A3 (B1)
To remove the space between text
=SUBSTITUTE(B1," ","")
To remove the specific number of digit
=LEFT(A2, LEN(A2)-2)
Removes last two characters from contents of A2 (Vitamin)
=RIGHT(A3, LEN(A3)-8) Removes first 8 characters from A3 (B1)