How to set cell character size

gruvinonu · Apr 19th, 2002, 06:42 PM

I've got a bunch of text in a cell and i'd like to cut it down from 100 characters to 30... can i do this automatically and with multiple rows at once?

fdrl · Apr 19th, 2002, 07:17 PM

Do you mean you want to delete any text in excess of 30 characters, or do you want to wrap the text so that it is only 30 characters wide?

Yogi Anand · Apr 19th, 2002, 08:28 PM

Quote:

On 2002-04-19 17:42, gruvinonu wrote:
I've got a bunch of text in a cell and i'd like to cut it down from 100 characters to 30... can i do this automatically and with multiple rows at once?

It is not clear what you intend to do.

If you want to reduce the character size, then select the cell or cells that you want to operate on, then go to the formatting tool bar and reduce the font size.

If you want to reduce the number of characters in the cell from 100 to 30, then you will need to use a formula in an adjacent cell

=LEFT(A1,30)

A little clearer explanation what you are trying to accomplish will help!

eliW · Apr 20th, 2002, 12:02 PM

Quote:

On 2002-04-19 17:42, gruvinonu wrote:
I've got a bunch of text in a cell and i'd like to cut it down from 100 characters to 30... can i do this automatically and with multiple rows at once?

Hi gruvinonu,
From your menu you can use: Data | Text to colunns, which opens a wizard. Follow the steps. You can choose to import a fixed width text by marking the desired length.
Eli

gruvinonu · Apr 22nd, 2002, 09:44 PM

Thank you for responding. I'll try to be more specific. I only want 30 characters total in the cell...anything past that should be ignored/discarded. Thanks again

Tom Schreiner · Apr 22nd, 2002, 09:54 PM

Hi Gruv
Select the cells in question and then run this macro...

Sub DownText()
Dim c As Object
For Each c In Selection
If Len(c.Value) > 30 Then c.Value = Left(c.Value, 30)
Next
End Sub

Tom

anno · Apr 22nd, 2002, 09:55 PM

gruvinonu
yogi's solution will do that.

[ This Message was edited by: anno on 2002-04-22 20:56 ]

Tom Schreiner · Apr 22nd, 2002, 09:58 PM

I know...
Will not need any formulas this way, however.

anno · Apr 22nd, 2002, 10:05 PM

Quote:

On 2002-04-22 20:55, anno wrote:
gruvinonu
yogi's solution will do that.

[ This Message was edited by: anno on 2002-04-22 20:56 ]

tom
this comment was for gruvinonu - i wasn't criticising your idea

Tom Schreiner · Apr 22nd, 2002, 10:14 PM

No problem Anno...
Yogi has helped me out more than once.
If someone will not take the time to post a few details, I don't spend alot of time with a solution...
The little macro seemed to be the easiest way for me to help the guy.
Tom

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 19th, 2002, 06:42 PM	#1
gruvinonu New Member Join Date: Apr 2002 Posts: 3	I've got a bunch of text in a cell and i'd like to cut it down from 100 characters to 30... can i do this automatically and with multiple rows at once?

Apr 19th, 2002, 07:17 PM	#2
fdrl Join Date: Apr 2002 Posts: 12	Do you mean you want to delete any text in excess of 30 characters, or do you want to wrap the text so that it is only 30 characters wide?

Apr 22nd, 2002, 09:44 PM	#5
gruvinonu New Member Join Date: Apr 2002 Posts: 3	Thank you for responding. I'll try to be more specific. I only want 30 characters total in the cell...anything past that should be ignored/discarded. Thanks again

Apr 22nd, 2002, 09:54 PM	#6
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Hi Gruv Select the cells in question and then run this macro... Sub DownText() Dim c As Object For Each c In Selection If Len(c.Value) > 30 Then c.Value = Left(c.Value, 30) Next End Sub Tom

Apr 22nd, 2002, 09:55 PM	#7
anno Board Regular Join Date: Feb 2002 Posts: 202	gruvinonu yogi's solution will do that. [ This Message was edited by: anno on 2002-04-22 20:56 ]

Apr 22nd, 2002, 09:58 PM	#8
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	I know... Will not need any formulas this way, however.

Apr 22nd, 2002, 10:14 PM	#10
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	No problem Anno... Yogi has helped me out more than once. If someone will not take the time to post a few details, I don't spend alot of time with a solution... The little macro seemed to be the easiest way for me to help the guy. Tom