End of Cell

D

David Yeager

Is there a function that returns a boolean value for when
the end of a cell has been reached?
Essentially, what I need to do is format data so that a
part name is displayed (up to 32 characters), followed by
periods until the end of the cell, followed on the next
line IN THE SAME cell with any leftover characters in the
part name (in other words, all characters above 32).
I'm stumped. Any help would be appreciated.

TIA,
Dave
 
W

William

=A1&REPT(".",32-LEN(A1))

--
XL2002
Regards

William
[email protected]

| Is there a function that returns a boolean value for when
| the end of a cell has been reached?
| Essentially, what I need to do is format data so that a
| part name is displayed (up to 32 characters), followed by
| periods until the end of the cell, followed on the next
| line IN THE SAME cell with any leftover characters in the
| part name (in other words, all characters above 32).
| I'm stumped. Any help would be appreciated.
|
| TIA,
| Dave
 
P

Pete

Sorry

Didn't mean to post that response as it does not answer your question fully.
Apologies.

--

Regards

Pete
|
| =A1&REPT(".",32-LEN(A1))
|
| --
| XL2002
| Regards
|
| William
| [email protected]
|
| | | Is there a function that returns a boolean value for when
| | the end of a cell has been reached?
| | Essentially, what I need to do is format data so that a
| | part name is displayed (up to 32 characters), followed by
| | periods until the end of the cell, followed on the next
| | line IN THE SAME cell with any leftover characters in the
| | part name (in other words, all characters above 32).
| | I'm stumped. Any help would be appreciated.
| |
| | TIA,
| | Dave
|
|
 
Top