End of Cell

  • Thread starter Thread starter David Yeager
  • Start date Start date
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
 
=A1&REPT(".",32-LEN(A1))

--
XL2002
Regards

William
(e-mail address removed)

| 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
 
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
| (e-mail address removed)
|
| | | 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
|
|
 
Back
Top