Text in tables

Aaron424 · May 2nd, 2002, 10:36 AM

I am converting a Word table into an embedded Excel worksheet within Word. I need the text in the leftmost column to be followed by dot leaders filling the remainder of the cell (SEC reporting format requirements, eg.

Column A Column B
Text.................... ####
More text............... ###

I have tried using periods following the text. However, when you print the page, the periods truncate inconsistently at the end of the cell. I need them to cut off as if justified on the right. I am not aware of tab stop settings in Excel, so I imagine I would need to use a custom cell format. Any suggestions?

Anne Troy · May 2nd, 2002, 11:18 AM

There aren't any.

I'm wondering why you are moving it to Excel. If there are some calculations, a minimum amount can be done in Word. But you won't (certainly not easily) get this format to work for you in Excel.

Try doing it in a textbox?

May 2nd, 2002, 11:18 AM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	There aren't any. I'm wondering why you are moving it to Excel. If there are some calculations, a minimum amount can be done in Word. But you won't (certainly not easily) get this format to work for you in Excel. Try doing it in a textbox? __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 2nd, 2002, 10:36 AM	#1
Aaron424 New Member Join Date: May 2002 Posts: 2	I am converting a Word table into an embedded Excel worksheet within Word. I need the text in the leftmost column to be followed by dot leaders filling the remainder of the cell (SEC reporting format requirements, eg. Column A Column B Text.................... #### More text............... ### I have tried using periods following the text. However, when you print the page, the periods truncate inconsistently at the end of the cell. I need them to cut off as if justified on the right. I am not aware of tab stop settings in Excel, so I imagine I would need to use a custom cell format. Any suggestions?