Left

Fills a selected range of at least two columns with the contents of the far right cell.

To access this command...

Choose Sheet - Fill Cells - Left.

If a selected range has only one row, the content of the far right cell is copied into all other cells of the range. If several rows are selected, the far right cells are copied into the cells to the left.