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:


[table="width: 500, class: grid"]
[tr]
[td] Marie[/td]
[/tr]
[tr]
[td] Marie Jane[/td]
[/tr]
[tr]
[td] Marie Jane and Clark Kent[/td]
[/tr]
[/table]


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)