If I have a cell with a string, like 123AB, is there a way I can use a macro to move the letters to the front of the string?
Option Explicit
Sub moveData()
Dim LastRow As Long
Dim x As Integer
Worksheets("Main").Activate
LastRow = Range("C65536").End(xlUp).row
For x = 1 To LastRow
If Range("C" & x).Value <> "" Then
'Call a function that moves any characters to the front.
End If
Next x
End Sub
Sub moveCharacters(theTarget As String)
'move the characters.
End Sub
So does anyone know how to do this? The format is generally the same but could slightly vary.
123AB
123A
12AB
1AB
etc.
But the end result does the same thing to each value.
AB123
A123
AB12
AB1
etc.
I appreciate your guys help.
Bookmarks