How to remove Empty Space in the Cell

Hi,

How to remove Starting Empty space in a cell

Input

Pack my box with five dozen liquor Jugs

Required Output

Pack my box with five dozen liquor Jugs

How to remove the <first empty space> before the wore <Pack> Please Help with a formula. Thanks in advance

Hi,

Just a tip. It's easier to see you problem in context if you copy the offending cell and paste it here wrapped between code tags. That way we can observe the problem in its own environment. It's not immediately obvious from the text above.

However the answer is

Please Login or Register  to view this content.

Rgds

thank you thank you