Thread
:
CopyText
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
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 With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]