Using TRIM with variable length fields

[Maggielove]

Is it possible to use TRIM where the field lengths are not consistent? I need to remove the first character of a field but the length varies between 4 and 8 characters, so wondered what the options were please.

 

[Maggielove]

Have tried this but it doesn’t produce any results at all unfortunately.

 

[tyija1995]

So you just want a procedure to return all of the strings within the range D2:D2001 excluding the first character?

Sub CutFirstChar()
Dim rng As Range
Dim cell As Range
Dim txt As String


Set rng = Range("D2:D2001")


    For Each cell In rng
        txt = Mid(cell.Value, 2)
        cell.Value = txt
    Next cell
End Sub

You could just use an Excel formula for this as well
=MID(D2, 2, LEN(D2)-1)
Then drag it down?

Is this what you are looking for??

 

[Maggielove]

Thanks for your comments. This is only one part of a very large macro which produces a journal output file, having moved data from various places and collated it. My issue is still with removing the first character from a range of cells with varying lengths.

 

[Fluff]

Can you explain in what way things are not working, also please post some samples of the data you are working with.