How to remove leading blank spaces in front of any word in column

My 1st ll rows consist of a dashboard. There is not data in these 11 rows.

I have 2 columns with data.

Column 3 has a permanent list of names with no leading spaces.

Column 8 has a list of names that:

1. Some words have no leading blank spaces.
2. Some words have 1 blank space in front of them.
3. Some words have 2 blank spaces in front of any word.

I need to have a macro that deletes all leading blank spaces in all words in column 8. When all leading blank spaces have been cleared, All the names in Column 8 need to be appended to column 3 at the bottom of the column.

Try Text to Column by Highlight the column (1 column at a time) > Go to Data > Text to Column. Make sure you choose Delimited, and check space check box.

Good hearing from you rylo . . .

Please look at the code on this reply. You will know better than by my trying to describe it.

'Sorry, I forgot to tell you that all data in column 8, with the exception of rows 1 : 11.
'Need code to delete all data from last name in column 8 up thru row 12

Sub EliminateLeadingBlanks()
Dim i
  For i = 12 To Cells(Rows.Count, 8).End(xlUp).Row
    Cells(Rows.Count, 3).End(xlUp).Offset(1, 0).Value = Trim(Cells(i, 8).Value)
  Next i
  'WORKS PERFECT TO HERE !
  
  
  
    'NEED CODE HERE  
  
  
End Sub

Thanks Rylo . . .

I sure enjoy how you code. It takes a certain type of programmer to have clean code like yours. You also knew immediately what I was asking for.

It works perfect.

I'll be sending you a private message in the near future. I am sure you can help me.

Many Thanks and Merry Christmas To You and Yours,

Matt & Macy Gentry

I'll mark this solved.