View Single Post
  #2  
Old August 27th, 2010, 01:30 PM
Brian J Hoskins Brian J Hoskins is offline
Member
 
First recorded activity by OfficeFrustration: Aug 2010
Location: South Wales, UK
Posts: 1
Send a message via MSN to Brian J Hoskins
Default

Quote:
Originally Posted by juanb007 View Post
hi all !!!

I have a large file in which I need to put a comma in the end of each line how can I do that with the replace function?

thanks a lot for your help!

juan
This sounds like a job for VBA to me. It depends on your exact requirements. Can you clarify the following please:

1. Will the comma be placed at the end of each line regardless of whether there is any text on that line (i.e. a comma will be placed at the end of blank lines as well) or will the comma only be placed on lines where there is some text?

2. When you say "end of the line", do you mean you want a comma placed immediately where the text on the line finishes or do you mean you want a comma placed at the literal end of line?

3. Are there any lines that you would not want a comma placed at the end? For example, blank lines or heading lines etc.

And finally, out of interest, what is this for?

Cheers,

Brian