| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
truncate text in each cell in column
Works fine. Thanks!
"Chip Pearson" wrote: The problem is that rngCell is being set to then entire column N. Try For Each rngCell In Columns("N:N").Cells or, better, For Each rngCell In Application.Intersect( _ ActiveSheet.UsedRange, ActiveSheet.Columns("N")).Cells Cordially, Chip Pearson Microsoft MVP Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Thu, 27 Nov 2008 07:06:00 -0800, Jake wrote: For Each rngCell In Columns("N:N") rngCell.Value = Left(CStr(rngCell), 35) Next rngCell |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i truncate text-- create cell with only 125 charecters | Excel Worksheet Functions | |||
| How do I set up macro to truncate column/field? | Excel Programming | |||
| Truncate Cell text all the time | Excel Programming | |||
| Truncate text | Excel Programming | |||
| Truncate text | Excel Programming | |||
Threaded Mode
