Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
A column has values similar to this:
Austin, TX 45124 San Antonio, TX 45147 My goal is to move the state to the next column over, and the zip to the column after state. I can copy the state and zip, but I don't know how to "move", or cut and paste them. Here is where I am starting: Sub moveAddress() Dim full As String Dim state As String Dim zip As String Dim pos As Long For Each Cell In Range("e2:e4") full = Cell.Text pos = InStr(full, ",") state = Mid(full, pos, 4) Cell.Offset(0, 1).Value = state Next Cell End Sub Again, this copies the state, but doesn't move it. I have found many posts that move the entire contents of a cell, but obviously I can't do that. Thanks -tom |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Search/Match/Find ANY part of string to ANY part of Cell Value | Excel Worksheet Functions | |||
Move part of cell only - help please | Excel Discussion (Misc queries) | |||
removing part of text string to another cell | Excel Discussion (Misc queries) | |||
select part of a cell value string | Excel Discussion (Misc queries) | |||
move part of cell to new column | Excel Programming |