Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
merge cells and save as .txt file
Hello everyone
well, I'm german and I am a newbie in VBA, so I hope I can describe my problem as good as necessary. I got a table (.txt or similiar file) which looks like this: ..blablabla.com ..shalalal.de ..sdölfkh.com ..weaklrfjd.com ..sdfjlöajf.com ..waefasdf.de ..lwöeakfjl.de and so on (fictive words ;) afterwards it should look like this: ( url contains ".blablabla.com" or url contains ".shalalal.de" or url contains... .de ) Now i got two problems. This text-transformation is recurrent, so I thought creating a userform in Excel would be the best solution. But how do I merge 2 cells (can't find any help)? And, is there any way to save the result as a normal .txt file without "extra" quotationmarks?? (like this: "".blablabla.com""). Because I think saving it as a .prn file and renaming it can't be a sufficient solution. I would be really grateful for every help!! Greets, Christof |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
merge cells and save as .txt file
thx a lot
this is indeed a much easier solution!! works perfectly!!! Greets, Christof |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I've added hyperlinks to cells, but when I save the file they don' | Excel Discussion (Misc queries) | |||
How to Filter cells and save the file with certain criteria? | New Users to Excel | |||
Disallow File Save if No Input in Cells? | Excel Discussion (Misc queries) | |||
I get error messages in Excel cells once I save a file | Excel Worksheet Functions | |||
The merge cells toolbar is disabeled in a file why? | Excel Discussion (Misc queries) |