Hi Lalit_Mohan
Great work ! wow ! excellent !This works perfect!
U are really a expert and a genius in this field
This will really save a lot of time and work for me
Regards
Vijay yadav
On Thursday, 28 June 2012 15:39:56 UTC+5:30, vijay yadav wrote:
Dear members,
Please help me
The macro below does exactly what is need but it doesn't prefix the letters
before the hypen.
eg 1
X6-1,4,5,6,9,X7-23,56,67,X30 in cell C34
ANSWER by using below macro -
X6-1 in cell c34
4 in cell c35
5 in cell C36
6 in cell C37
9 in cell C38 I want X6- also as a prefix
23
Hi Vijay,
Hope it helps you
Sub SeperateData()
Dim varVal As Variant
Dim lngLoop As Long
Dim rngRangeAs Range
Dim strIni As String
Dim strFinalAs String
Set rngRange = ActiveSheet.Range(A1)
varVal =
HI,
Hope this will meet your expectation
Sub SeperateData()
Dim varVal As Variant
Dim lngLoop As Long
Dim rngRangeAs Range
Dim strIni As String
Dim strFinalAs String
Dim strTemp As String
Dim lngVal
Nice Pandey ;)
On Fri, Jun 29, 2012 at 12:22 AM, vijay yadav
vijay.ganesh.ya...@gmail.comwrote:
Thanks Lalit_Mohan
,You are a genius,great work done.
This gives me 95 % correct results but due to 2 bug or errors I have to
check everything and correct it.
The bug or errors are
1)THE X