LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change Cell Width WITHOUT changing Column width dww701 Excel Discussion (Misc queries) 1 January 12th 09 10:52 PM
Using IF function then Autofill-increments down a reference cell Twinspot Excel Worksheet Functions 2 November 26th 07 10:44 AM
I want to get remaining text after using LEFT function Munawar Amin Excel Worksheet Functions 3 November 6th 06 03:58 PM
How to make cell width different than the column width it lies in John Excel Discussion (Misc queries) 2 September 11th 06 10:41 PM
Is there a function to show if cell/row(X:Y) is hidden? or width? Joseph in Atlanta Excel Worksheet Functions 3 March 17th 06 05:57 AM


All times are GMT +1. The time now is 12:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"