Hide text with format after nth character (input field)

[improvet]

Hi,

After the 8:th charachter I would like to either change the color to white or just not show them. Is this possible?

Example:

12345678#abc

The charachters after # is optional code for input to a formula, and are also the ones I want to hide.


Rather not use vba for this but it seems like it's the only solution right now.

 

[SteveO59L]

how is the cell populated?

 

[improvet]

it's populated like this:
23044563#45

The first set of numbers always have the 8 digit length.
It can be up to 4 numbers after #.
After the first set of 8 numbers everything else should be "invisible" but still readable by a formula.

So either with the same color as the background (vba is the only way I can think of for accomplishing this), or #+numbers not shown via a custom format if possible

Unless there are other possibilities?

 

[István Hirsch]

Try this:

=TEXT(LEFT(A2,8),"00000000")

 

[improvet]

Try this:

=TEXT(LEFT(A2,8),"00000000")

It's an input field where I want this to happen in

 

[SteveO59L]

so a person types "23044563#45" into a cell, but you only want to show the "23044563"

is this in a specific cell or column?

 

[improvet]

so a person types "23044563#45" into a cell, but you only want to show the "23044563"

Yes that's correct

It's in a specific cell

 

[SteveO59L]

and the specific cell is?

 

[improvet]

If you mean cell position its "A2"