left() for single cell?

**mpkavanagh** · 01-12-2011, 06:04 PM

I am trying to use the 'left()' command on a single cell of data within a macro. For example, if I want to limit A1 to 5 characters from the left, what would the code look like?

Apologies if this is an easy one, I have searched around and I can't get it right. *sigh*

Thanks!

**teylyn** · 01-12-2011, 06:10 PM

Hello,

something along the lines of

Please Login or Register  to view this content.

**watersev** · 01-12-2011, 06:13 PM

Please Login or Register  to view this content.

To control number of symbols you can use in-built validation tool.

**mpkavanagh** · 01-12-2011, 06:18 PM

Not working. Do I need to declare anything? I am very new to VBA and programming in general and I am learning through trial/error...

For example:

Please Login or Register  to view this content.

Is what I have. I am thinking I am missing something...

**teylyn** · 01-12-2011, 06:28 PM

You will have to write the result back into the cell, of course, like watersev shows, or using the Range() long hand.

Please Login or Register  to view this content.

I'm not sure what you mean by "I want to limit". You'll need to explain a bit more what you want to do or post a workbook with before and after so we can see what you want to achieve.

**mpkavanagh** · 01-12-2011, 06:30 PM

Thanks! It worked. I appreciate the speedy help.

By "limit" I meant keep only a certain number of characters. Basically, I wanted 123456 to return 1234 if I chose 4 characters.