ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Dashes in cells (https://www.excelbanter.com/new-users-excel/454545-dashes-cells.html)

Gary C[_2_] January 12th 20 01:37 AM

Dashes in cells
 
Cols A thru M have varying widths.

Cells A1 thru M1 contain data.
Cells A2 thru M2 are empty.
Cells A3 thru M3 contain data.

I want each cell in A2 thru M2 to contain a string of dashes (i.e., "-"). Each string must have the same length as the column-widths in the adjacent columns.

How do I do that?


All times are GMT +1. The time now is 02:00 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
ExcelBanter.com