filling blank cell with value to the left

[mrxwanttobe]

Hello. I see where I can fill an empty cell with the value above or below but how about the cell to the left? Thanks

 

[Joe4]

If you select the cell with value in it, click on the + sign in the bottom right-hand corner and hold and drag to the cell to the right of it, it should fill it in with that value.

If that is not what you are looking for, please provide more detail.

 

[mrxwanttobe]

hi. I guess I wasn't very clear. My column has 50,000 lines and about 500 of them are blank and the cell to the left has the value I need.

 

[Joe4]

If you were talking about this method when saying you know how to do it with the value above or below: https://www.ablebits.com/office-addins-blog/2014/05/02/fill-blanks-excel/,
you can use the exact same method. The only difference is when entering the formula, enter the cell reference of the cell to the left instead of the cell reference of the cell just above or below.