Display part of the cell content (same cell)

[nickolas]

Hi gurus,

Can you please help me? I need to display in the cell just part of the content.
E.g. A1 has ABCD content inside; I need this cell display AB only.
Formula LEFT does not work for me. I guess a need a marco or something,
can somebody help?

Cheers all in advance!

Niko

 

[SteveO59L]

So you would to display only the first 2 characters?

How is the cell populated ?

 

[Simon Lloyd]

Do you want to remove everything else or hide it?

 

[nickolas]

Hi, thanx for a quicky.

Both would work for me. I guess remove would be even better.

Cheers!

 

[nickolas]

Do you want to remove everything else or hide it?

Yes first 2 for example or 3. It is a column of values

 

[nickolas]

So you would to display only the first 2 characters?

How is the cell populated ?

Yes first 2 for example or 3. It is a column of values

 

[pgc01]

Hi Nickolas

You can use Text to Columns to keep just the 2 first characters, using the option Fixed Width.