Oct 4, 2010 #1 crapplet MIS Joined Aug 13, 2010 Messages 5 Location US Is there a way to reformat text currently in column format to horizontal. For example I have data such as: Denver Dallas New Orleans Baton Rouge Seattle I would like to re-format the data to: Denver, Dallas, New Orleans, Baton Rouge, Seattle Thank you in advance
Is there a way to reformat text currently in column format to horizontal. For example I have data such as: Denver Dallas New Orleans Baton Rouge Seattle I would like to re-format the data to: Denver, Dallas, New Orleans, Baton Rouge, Seattle Thank you in advance
Oct 4, 2010 #2 PHV MIS Joined Nov 8, 2002 Messages 53,708 Location FR A starting point: Code: Set objFSO = CreateObject("Scripting.FileSystemObject") Set objFile = objFSO.OpenTextFile("input.txt", 1) strLine = Replace(objFile.ReadAll, vbCrLf, ", ") objFile.Close MsgBox strLine Hope This Helps, PH. FAQ219-2884 FAQ181-2886 Upvote 0 Downvote
A starting point: Code: Set objFSO = CreateObject("Scripting.FileSystemObject") Set objFile = objFSO.OpenTextFile("input.txt", 1) strLine = Replace(objFile.ReadAll, vbCrLf, ", ") objFile.Close MsgBox strLine Hope This Helps, PH. FAQ219-2884 FAQ181-2886
Oct 4, 2010 Thread starter #3 crapplet MIS Joined Aug 13, 2010 Messages 5 Location US wow, i was seriously over thinking that, thank you very much!!! Upvote 0 Downvote