Formatting merged cells to have lines.

[lsu-i-like]

I would like to know if there is a way to format merged cells so that lines show up where each cell would be.

Instead of having a cell look like this...

TEST

I want my cell to look like this...

T|E|S|T

But I want to be able to enter an entire word into the cell, not have to do it letter by letter. I'm thinking right now the only way to do that would be to enter data into one cell and then read it letter by letter and insert each letter into a single cell.

[Dave Peterson]

If you put a word in A1, you can put a bunch of formulas in B1:X1 (enough cells
for each letter):

in B1:
=mid(a1,1,1)
in C1:
=mid(a1,2,1)
in d1:
=mid(a1,3,1)
.....

You could even be a little sneaky.
Put this in B1 and drag across:
=MID($A1,COLUMN()-1,1)

or no matter what column if you start with the cell to its right:
=MID($A1,COLUMN()-COLUMN($A1),1)

Change $a1 to the cell that holds the word -- in both spots.

lsu-i-like wrote:
>
> I would like to know if there is a way to format merged cells so that
> lines show up where each cell would be.
>
> Instead of having a cell look like this...
>
> _TEST_
>
> I want my cell to look like this...
>
> _T|E|S|T_
>
> But I want to be able to enter an entire word into the cell, not have
> to do it letter by letter. I'm thinking right now the only way to do
> that would be to enter data into one cell and then read it letter by
> letter and insert each letter into a single cell.
>
> --
> lsu-i-like
> ------------------------------------------------------------------------
> lsu-i-like's Profile: http://www.excelforum.com/member.php...o&userid=14317
> View this thread: http://www.excelforum.com/showthread...hreadid=485854

--

Dave Peterson