Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How can I add commas? 1

Status
Not open for further replies.

lilcam

MIS
Apr 22, 2002
52
US
I have a long list of names, over 300 to be exact.

ahibbs
bcook
jhunter
lstevenson
etc ...

Is it possible to make it appear as the follwoing?

ahibbs,bcook,jhunter,lstevenson,etc ...

Takes too long to do it manually.
 
You will need to replace the CR and LF chars with a ,

If the solution is here, let us know it was helpful so others can benefit from it as too
 
lilcam ... what Office program are you trying to do this in?
Word,Excel..Outlook?
With that info. posting the proper answer will be much easier
Michael
 
I got it! Replaced all paragraph (^p) with , and that did the trick!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top