Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Change Cell Width WITHOUT changing Column width | Excel Discussion (Misc queries) | |||
Using IF function then Autofill-increments down a reference cell | Excel Worksheet Functions | |||
I want to get remaining text after using LEFT function | Excel Worksheet Functions | |||
How to make cell width different than the column width it lies in | Excel Discussion (Misc queries) | |||
Is there a function to show if cell/row(X:Y) is hidden? or width? | Excel Worksheet Functions |