Is this possible

[bam12]

If I put a value into a cell, is it possible to move it to other
cells
example. In cell A1 put 0198
cell B1 contains the following 6-0197-0001. I want the cell contents
of A1 to replace the 0197, so that the contents of cell B1
is now 6-0198-0001.
This will happen to many rows

 

[VoG]

This assumes that column A is formatted as Text so that when you enter 0198 it displays as 0198 not 198.

Right click the sheet tab, select View Code and paste in

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then
    If Target.Offset(, 1).Value <> "" Then
        Application.EnableEvents = False
            With Target.Offset(, 1)
                .Value = Left(.Value, 2) & Target.Value & Right(.Value, 5)
            End With
        Application.EnableEvents = True
    End If
End If
End Sub

Then press ALT + Q to close the code window.

 

[Matty]

Hi,

Can the following digits change:

6-####-0001

Or will they remain static?

Matty