Function to autofill remaining width of a cell

[Kate]

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!

 

[Jacob Skaria]

Try using REPT() function. The below will return 150 dots...I am not sure
whether this will be of help to you..

=REPT(".",150)


If this post helps click Yes

 

[Kate]

Thanks. The issue is that the # of repeats of " , " would vary depending on
the number of characters in the guest name / table number.

Below is an example of what I am trying to generate...not sure if there is a
function that will save me from manually typing middle section, and will also
fit the data to the exact width of my column.

Mr. and Mrs. John Smith . . . . . . . . 14
Ms. Jane Doe . . . . . . . . . . . . . . . . . 5

 

[Jacob Skaria]

If you are using monospace fonts this will work..If you have name in A1. Try
something like =A1 & REPT("." , 50-len(A1)).

If this post helps click Yes

 

[Fred Smith]

I would do it as follows.
1. Assume your names are in column A.
2. In column B, use the formula =a1&rept(". ",100) and copy down
3. Set the width of column B as desired.
4. Put your table number in column C.
5. Print columns B and C.

It doesn't matter if you have too many dots in column B, because Excel will
print only the width set (as long as there's something in column C). So you
don't need to fill the exact width of the column, you just need to make sure
it's filled to at least the width you need.

Regards,
Fred.

 

[Dave Peterson]

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