Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CopyText
I want to copy part of the text from one column to another. The text
has a \ in it and I need everything to the right of the \. If cell a has adcd\efg and I was coping it to cell b then cell b would have efg. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
CopyText
try this
Sub findslash() For Each c In Selection x = InStr(c, "\") 'MsgBox x c.Offset(, 1) = Right(c, Len(c) - x) Next End Sub -- Don Guillett SalesAid Software "Jeff" wrote in message ... I want to copy part of the text from one column to another. The text has a \ in it and I need everything to the right of the \. If cell a has adcd\efg and I was coping it to cell b then cell b would have efg. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|