| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Limit characters
For Each cell In Me.Range("A2:A301")
cell.Value = Left(cell.Value, 15) Next cell -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Patrick Simonds" wrote in message ... I use the code below to populate column A. Is there any way to change the code to limit it to the first 15 characters from the left? Me.Range("A2:A301").Value = Me.Range("B2:B301").Value |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Limit to 5 characters... | Excel Worksheet Functions | |||
| How to limit the characters in a cell | Excel Worksheet Functions | |||
| How do I limit characters in a cell? | Excel Worksheet Functions | |||
| limit of characters in Excell | Excel Discussion (Misc queries) | |||
| SQL limit of 255 characters | Excel Programming | |||
Threaded Mode
