Calling Excel Experts..issue Solved Thanks

[vikuba]

scenario

ila undhi matter naa deggara

insert into table.col(val1)
insert into table.col(val2)
insert into table.col(val2)

naaku kavalsindhi..ila

insert into table.col(val1)
with
insert into table.col(val2)
with
insert into table.col(val2)

How ??

Macro is the Answer

Sub InsertLines()
Dim wks As Worksheet
Dim rng As Range
Set wks = ActiveSheet
With wks
Set rng = .Cells(Rows.Count, "A").End(xlUp)
Do While rng.Row > 1
rng.EntireRow.Insert
rng.Offset(-1, 0).Value = "'HERE WE go"
Set rng = rng.Offset(-2, 0)
Loop
End With
End Sub

[vikuba]

1000 kanna ekuva unaaye statments ala...so with paste cheskuntu velli ani maatram cheppakandi..
edhaina delimited seperator options with next line lanti tricks untey cheppandi

[ChampakDas]

this is the rawest method that striked at first glance.

Find what ')' replace ' )<enter> with'

[Guest]

Textpad or notepad++ lo copy karo

then use Replace all ")" with ") with".

[sandy437]

in textpad , there will record macro. , record your action for two times , then click on play button which will do the rest...

[ChampakDas]

If any of the above methods doesnt suit your requirements, I can send you an exe which will do your job.

[vikuba]

[quote name='ChampakDas' timestamp='1344268085' post='1302264198']
If any of the above methods doesnt suit your requirements, I can send you an exe which will do your job.
[/quote]mama email address pm ed...send to it

[jaffanajeffada]

easy bayya,

1.notepad ++ install chey
2. open your document in that
3. Hit CTRL+H (replace)
4. Find what lo ) ivvu
5. Replace with lo ) \n with
6. Search mode lo Extended select chey
7. Replace/Replace All kottu

[ronitreddy]

[quote name='jaffanajeffada' timestamp='1344269071' post='1302264288']
easy bayya,

1.notepad ++ install chey
2. open your document in that
3. Hit CTRL+H (replace)
4. Find what lo ) ivvu
5. Replace with lo ) \n with
6. Search mode lo Extended select chey
7. Replace/Replace All kottu
[/quote]

[jaffanajeffada]

[quote name='ronitreddy' timestamp='1344269415' post='1302264322']


[/quote]
wassup bro? Hru doing??

[jaffanajeffada]

[quote name='sandy437' timestamp='1344267820' post='1302264173']
in textpad , there will record macro. , record your action for two times , then click on play button which will do the rest...
[/quote]
ivvala kotha trick nerchukunna

[k2s]

[quote name='Aamphat' timestamp='1344267408' post='1302264136']
scenario

ila undhi matter naa deggara

insert into table.col(val1)
insert into table.col(val2)
insert into table.col(val2)

naaku kavalsindhi..ila

insert into table.col(val1)
with
insert into table.col(val2)
with
insert into table.col(val2)

How ??
[/quote]
[quote name='jaffanajeffada' timestamp='1344269071' post='1302264288']
easy bayya,

1.notepad ++ install chey
2. open your document in that
3. Hit CTRL+H (replace)
4. Find what lo ) ivvu
5. Replace with lo ) \n with
6. Search mode lo Extended select chey
7. Replace/Replace All kottu
[/quote]
[quote name='sandy437' timestamp='1344267820' post='1302264173']
in textpad , there will record macro. , record your action for two times , then click on play button which will do the rest...
[/quote]

[jaffanajeffada]

[quote name='k2s' timestamp='1344271954' post='1302264595']

[/quote]
dheenlo thinking endhi vayya k2suuuuuuu

[vikuba]

aapice mein no notepad++ yaa
wil try thanks[quote name='jaffanajeffada' timestamp='1344269071' post='1302264288']
easy bayya,

1.notepad ++ install chey
2. open your document in that
3. Hit CTRL+H (replace)
4. Find what lo ) ivvu
5. Replace with lo ) \n with
6. Search mode lo Extended select chey
7. Replace/Replace All kottu
[/quote]

[vikuba]

naaku' with ' phrase next line kavaali not in same line..
excel or notepad tools maatramey unaaye..
ultra edit wordpad...veetillo kudirtey cheppandi