View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kate kate is offline
external usenet poster
 
Posts: 112
Default Function to autofill remaining width of a cell

Hello, I am trying to use Excel data to form a column for a seating chart
that I am designing in Adobe Illustrator. I need the data within the cell to
list the guest name (characters will vary) aligned to the left, a series of
spaces and dots, followed by their table number - aligned to the right.

Is there a formula I can enter that will auto fill the appropriate # spaces
and dots between the name and table number - so that I don't have to do this
manually? I would like the end result to be one (or however many necessary)
column / list that fills my column width precisely.

If no, do you have any other suggestions? My data is in Excel, but I could
always import to other Office apps if needed.

Thanks so much!