Strange Text Format Needed

[Yogi_Bear_79]

I have a work sheet that has a cell that consists of 5 cells across . The
cell gets it's data from another cell. Is their anyway to get the cell to
make part of the text go extreme left and the other portion extreme right?

=sheet1!C1 & Sheet1!C2

I'm tied into the current column widths because of data above. Iam working
on fixing that in lieu of this crazy idea

 

[zz]

try using the functions right and left

c1"=right(your_cell,number_of_characters_to_extract)"
c2"=left(your_cell,number_of_characters_to_extract)"

then use "=concatenate(c2,c1)"

 

[Dave Peterson]

If you know the width of the receiving cell, you could use a formula like:

=Sheet1!C1&REPT(" ",40-LEN(Sheet1!C1&Sheet1!C2))&Sheet1!C2

I made the width of the string 40 characters wide. With a proportional font,
you may have to experiment with what number you need to make it look pretty.

 

[Sandy Mann]

I have a work sheet that has a cell that consists of 5 cells across .

I assume that you mean you have 5 cells merged. If that is the case then
unmerge the cells and put the data left aligned in the left most cell and
right aligned in the right most cell. If you want to keep the cells merged
try:

Format > Cells > Number > Custom

Enter the custon format:
"Test it our to see"* #"If this will work for you"

Note that there is a space between the * and the #

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Sandy Mann]

I assume that you mean you have 5 cells merged. If that is the case then
unmerge the cells and put the data left aligned in the left most cell and
right aligned in the right most cell. If you want to keep the cells
merged try:

Format > Cells > Number > Custom

Enter the custon format:
"Test it our to see"* #"If this will work for you"

Note that there is a space between the * and the #

I omitted to add at the end of my post enter a 0 (zero) into the cell to get
the two pieces of text left & right aligned but no zero showing, (at least
in XL97).
--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk