Aligning Text
Aligning Text
(OP)
I'm using Excel 2007 to generate my quotes, and I need to concatenate a customers name and date but have them aligned left and right respectively in the same cell. Right now we just use spaces and it's a PITA to be honest. If only excel had the ability to split individual cells like you can in word's tables then it wouldn't be an issue. I know that I can add a new column but it screws up the rest of the document. Any ideas?





RE: Aligning Text
David
RE: Aligning Text
RE: Aligning Text
2. Merge all of the cells above and below the original cells that you wanted to "split".
3. Adjust the width of these columns.
4. Format the "split" cells for text alignment - voila!
RE: Aligning Text
Steve, your suggestion is what I tried before and gets messy with the rest of the document. I was hoping that Excel had some type of column that you could format to and have each side aligned differently or perform a soft split of the cells. I'm starting to think that I should just use Excel for what it was designed for...lol
RE: Aligning Text
CONCATENATE(D1,REPT(" ",40-LEN(D1)-LEN(TEXT(E1,"$ #####.00"))),TEXT(E1,"$ #####.00"))
Where D contains the text of the name, and E contains the dollar amount. This should result in a text column formatted for 40 characters wide.
htt
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: Aligning Text
Problem is that we have the customer name and date in the same cell/row so that would work until the customer name changed. Good idea and we more along the line of what I was thinking with some formulas.
Along those lines if I knew how many characters it took to fill the line on the page (before it wrapped to another row), could you count the spaces in the name add it with the date and subtract that from the total?
RE: Aligning Text
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: Aligning Text
RE: Aligning Text
RE: Aligning Text
TTFN
FAQ731-376: Eng-Tips.com Forum Policies