Need to remove space before text in every cell

[Sm3tUser]

In every cell in one of my columns, there is a single space before the text begins. The text inside the cell varies however in word length (does this make it harder to resolve?). Eg:

Marie

Marie Jane

Marie Jane and Clark Kent

Could someone please put together a formula for me to remove this space?


Thanks

 

[Michael M]

Use the TRIM function

Excel 2007
	A	B
1	Marie	Marie
2	Marie Jane	Marie Jane
3	Marie Jane and Clark Kent	Marie Jane and Clark Kent
Sheet1

Cell Formulas
Range	Formula
B1	=TRIM(A1)
B2	=TRIM(A2)
B3	=TRIM(A3)