Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Truncate Cell text all the time
I have the need to trucate the contents of my cells regardless of
whether or not there is content in the adjoining cell. Can anyone tell me how to do this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Truncate Cell text all the time
You could use code like the following:
Dim Rng As Range For Each Rng In Range("A1:A10") If Len(Rng(1,2).Text) < 0 Then Rng.Value = Left(Rng.Text,3) ' truncate to 3 characters End If Next Rng -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com wrote in message ups.com... I have the need to trucate the contents of my cells regardless of whether or not there is content in the adjoining cell. Can anyone tell me how to do this? |
Reply |
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 you truncate a text string? | Excel Worksheet Functions | |||
Truncate text | Excel Programming | |||
Truncate text | Excel Programming | |||
truncate text using VBA Excel | Excel Programming |