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

I would think using the built in formatting for Tabs in MSWord would be easier
than using excel.



Kate wrote:

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!


--

Dave Peterson