GohLS
02-15-2011, 09:03 AM
Hi All,
working on a code which will delete after the first space and keep the rest of the chara or value.
Eg: this-123-is-a-fox jumping over the wall
to "this-123-is-a-fox"
Total of chara may vary and there is no standard number of chara in the front.
so i just want to keep the front chara after the first space.
Tried
Range("A2") = Left$(.Value, InStrRev(.Value, " "))
NOt really working cos only delete the last space onwards.
Pls Help
Thanks
working on a code which will delete after the first space and keep the rest of the chara or value.
Eg: this-123-is-a-fox jumping over the wall
to "this-123-is-a-fox"
Total of chara may vary and there is no standard number of chara in the front.
so i just want to keep the front chara after the first space.
Tried
Range("A2") = Left$(.Value, InStrRev(.Value, " "))
NOt really working cos only delete the last space onwards.
Pls Help
Thanks