Anyways m using the below code for it...let me knw if there is any
flawsAlso can i use wildcards with instr function.
Sub Test()
Dim i As Long, sTemp As String
Dim stext As String
stext = Range("A1").Value
i = 1
Do
sTemp = Mid$(stext, i, 15)
sTemp = Repla
Hi Paul,
Yeah its working fineU did a great Job...Thanks for ur time.
On Sun, Apr 11, 2010 at 9:20 PM, paulwillekens <
paul.johan.willek...@gmail.com> wrote:
> Hi Anju,
>
> Of cours, you give too few examples, but at least for the two formats
> following macro shoud do the job.
>
> Give s
Hi Anju,
Of cours, you give too few examples, but at least for the two formats
following macro shoud do the job.
Give some feedback.
Kind regards,
Paul Willekens
'===
Sub PullNumber()
Dim cChar
Dim cContent
Dim cNumber
Dim lF
