How would I go about cutting off text in a pasted column and keepin
only the first 250 characters of each cell? Validating the colum
doesn't truncate like I want and nobody is entering data directly int
the spreadsheet - it's all copy and pasting. I've tried using lef
functions, but I'm failing miserably. Can somebody please help she
some light on this problem. I'm guessing it's probably a 2-3 lin
answer and I'm overthinking for a solution. ;)

Thanks

--
Message posted from http://www.ExcelForum.com

Hi
try something like the following macro (will truncate the active
Selection):
Sub trunc_left()
Dim rng As Range
Dim c As Range
Set rng = Selection
For Each c In rng
c.Value = Left(c.Value, 250)
Next
End Sub

--
Regards
Frank Kabel
Frankfurt, Germany

How would I go about cutting off text in a pasted column and keeping
only the first 250 characters of each cell? Validating the column
doesn't truncate like I want and nobody is entering data directly
into
the spreadsheet - it's all copy and pasting. I've tried using left
functions, but I'm failing miserably. Can somebody please help shed
some light on this problem. I'm guessing it's probably a 2-3 line
answer and I'm overthinking for a solution. ;)

Thanks!


---
Message posted from http://www.ExcelForum.com/

I've been trying a similar range function that looks something lik
this:

Sub TrimText()
Dim lLastRow As Long
Dim Sh1 As Worksheet, rng As Range

Set Sh1 = ThisWorkbook.Worksheets("Form")
lLastRow = Sh1.Cells(Rows.Count, "I").End(xlUp).Row
Set rng = Sh1.Range("I2", "I2" & lLastRow)

rng.Value = Left(rng.Value, 250)

Set Sh1 = Nothing
Set rng = Nothing
End Sub


However, nothing gets truncated when pasted in column I2+

--
Message posted from http://www.ExcelForum.com

I'm still having problems figuring this problem out. Can anyone pleas
help shed some light on it?

Thanks again

--
Message posted from http://www.ExcelForum.com

Hi
what is your problem. A little bit more detail would be helpful :-)


--
Regards
Frank Kabel
Frankfurt, Germany

I'm still having problems figuring this problem out. Can anyone
please help shed some light on it?

Thanks again!


---
Message posted from http://www.ExcelForum.com/

Sorry about that... It's still early and I'm not fully awake yet...

I used the formula you posted and the subroutine I posted above, bu
the text is still not being truncated when pasted into column I. Fo
example, let's say I have 10 rows of text being pasted into column
starting at I2. I1 is the column name header. All the information i
being pasted correctly, but nothing is being truncated.




Frank Kabel wrote:
[b]Hi
what is your problem. A little bit more detail would be helpful :-

--
Message posted from http://www.ExcelForum.com