Select only a certain chararcter count

[Scaiveau]

I need to copy a column, with 30 pLus chatarters in a column of no more than 30 Characrters.
When I go into Data validation, I can select my new colum to read only 30 charaters (so I match my importing format) but when I copy my 30+ characters column in my no more than 30 character, I get notified that my text is too long for each entry. I do not want to re-enter several 1000's of entries. I want my column to read the 1st 30 charatarter and leave behind the left over.

 

[Gerald Higgins]

Hi, welcome to the board.

You can use the =LEFT() function to return the first 30 characters from a string.

For example,

=LEFT(a1,30)

If you want to also show the remaining characters, you can use

=MID(a1,31,255)

 

[JamesW]

Hi there,

Welcome to the board.

Maybe try this:

Sub test()
    lRow = Range("A" & Application.Rows.Count).End(xlUp).Row
    For i = 2 To lRow
        Cells(i, 2).Value = Left(Cells(i, 1).Value, 30)
    Next i
End Sub

Change ranges to suit.

 

[Scaiveau]

Thank you Gerald

Hi, welcome to the board.

You can use the =LEFT() function to return the first 30 characters from a string.

For example,

=LEFT(a1,30)

If you want to also show the remaining characters, you can use

=MID(a1,31,255)

 

[Scaiveau]

Thank you