• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1672
  • Last Modified:

replace line feed with comma

I have a file that has a line feed at the end of each field.  When I try to do a 'replace' and hit the enter key, Word goes into a search and does not recognize that as the keystroke.  I see the 'other' choice but do not know what to put in to have it replaced with a comma.  When I reveal the codes in word, the character to be replaced looks like the letter 'L' mirrored with an arrow on top.  (I surmised that this is a line feed??)  All I want to do is replace the line feed with a comma?!??!   I thought that this would be easy.......
Thanks
Gus
0
GintarasUS
Asked:
GintarasUS
1 Solution
 
R_RajeshCommented:
Hi GintarasUS,

bring up the replace dialog (ctrl+h), enter ^l in the find what field and , in the replace with field then click on replace all

Rajesh
0
 
aflockhartCommented:
Not sure what version you are using.  In w2003, there is also a  "Special" button in the dialog box to give you all the special character options.

Other useful codes in similar situations include ^p for paragraph markers, ^m for page breaks and ^t for tabs.   You can use all of these in the search field or in the replace field, and you can search for sequences such as ^p^p  for multiple blank paragraphs.
0
 
chenslerCommented:
If this is a one-time problem, a quick solution would be to import the file into Excel.  The import dialogue box gives you all kind of options for how to import text.  You'd then be able to export it as a comma seperated file.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now