Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cut cells from column A that contain "/" Paste them to column B
Subject says it all. How do I search column A, find all cels that contain
the backslash character, then cut them from A and place them in Column B |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cut cells from column A that contain "/" Paste them to column B
Hi
try the following macro: Sub cut_rows() Dim lastrow As Long Dim row_index As Long Application.ScreenUpdating = False lastrow = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row For row_index = 1 to lastrow with Cells(row_index, 1) If instr(.Value, "\")0 then .offset(0,1).value=.value .clearcontents End If end with Next Application.ScreenUpdating = True End Sub -- Regards Frank Kabel Frankfurt, Germany "Yogi_Bear_79" schrieb im Newsbeitrag ... Subject says it all. How do I search column A, find all cels that contain the backslash character, then cut them from A and place them in Column B |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cut cells from column A that contain "/" Paste them to column B
Worked Perfectly..Many Thanks
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create Pivot Table Data with Column "Sum" rather than "count" defa | Excel Discussion (Misc queries) | |||
How do I change the column heading in Excel to display "A" "B" "C | New Users to Excel | |||
copy--paste--special "formula" for a whole column | Excel Discussion (Misc queries) | |||
Compare cells in column A ("ID") to column A ("ID)in two differen. | Excel Worksheet Functions | |||
how can I count if column A="active" and column E="Job" in a list? | Excel Worksheet Functions |