Remove space at beginning of cell in Excel

Have an Excel worksheet that contains 600 rows of data in a single column (Col A).
Each cell in Col A contains text proceeded by a space, example: " Text"
Is there a function or argument that I can use to remove the space from each cell in Col A?

Alternatively, you can use the Text-To-Columns function to clean up the column in-place without any formulas:
1) Select the entire column (click on "A" above row 1)
2) Select Excel menu: Data - Text to Columns
You'll see a new dialog box
3) Select "Delimited" option on top, then click the "Next" button
4) Under "Delimiters" on top, select "Space".
You'll see a vertical line appear to the left of the example text on the bottom.
5) Click the "Next" button
6) Under "Column data format" on top, select "Do not import this column (skip)".
This will skip the first column of one space only.
7) Click the "Finish" button.

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…

Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…