Thread: Dashes in cells
View Single Post
  #1   Report Post  
Old January 12th 20, 01:37 AM posted to microsoft.public.excel.newusers
Gary C[_2_] Gary C[_2_] is offline
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2017
Posts: 1
Default 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?