Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting merged cells to have lines.
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting merged cells to have lines.
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting on unprotected cells | Excel Discussion (Misc queries) | |||
Formatting a range of cells doesn't work | Excel Discussion (Misc queries) | |||
Conditionial formatting for merged cells, function Len($A$4) | Excel Worksheet Functions | |||
Auto fit merged cells | Excel Discussion (Misc queries) | |||
Cells losing formatting | Excel Discussion (Misc queries) |