Display a text in a cell

**axmt** · 12-19-2006, 08:21 AM

Hi,

I want to display a part of a text in a cell. That is, if I have the following text:

You have to reboot the system after install the program.

When I typed it in a cell the text is displayed in more than a cell, but I only want to display the part that covers one cell and the rest display it above. But I don't want to increase the size of the cell.

In the example would be:

You have to r That is what you see without modyfing the cell. And above to see all the text.

Is it possible to do it? If so, how?

Thanks.

**oldchippy** · 12-19-2006, 08:29 AM

Go to Format > Cells > Alignment and tick wrap text

**axmt** · 12-19-2006, 09:48 AM

Yes, it works. But it's not what I want exactly. What I want is to be able to introduce text and display only the text can be in the cell without modifying the size of it.

Is it possible to do it?

Thanks.

**oldchippy** · 12-19-2006, 09:54 AM

I'm not quite sure what you mean?

You put this text into A1

You have to reboot the system after install the program

but you can only see this?

You have to r

**axmt** · 12-20-2006, 04:14 AM

No. I put you have to reboot the system after install the program in A1 and I see the same as in the cell. And what I want is to see the whole sentence in A1 but only you have to rin the cell.

Is it possible to do it?

I hope it is clear now.

Thanks.

**Carim** · 12-20-2006, 04:17 AM

Hi,

Go to A1 ...
From menu, select Format Column AutoFit

HTH
Carim

**VBA Noob** · 12-20-2006, 04:24 AM

Hi,

If you put something in B1, it'll stop the overlap.

You can use an apostrophe ('), a spacebar ( ).

But I like to use a formula:

=""

It's easier to notice and weird enough to remind me why I did it.

VBA Noob