Link to home
Start Free TrialLog in
Avatar of Marcus Aurelius
Marcus AureliusFlag for United States of America

asked on

How to remove LINE FEED or CARRIAGE RETURN from data?

Experts,

I need to remove the LINE FEED after each COMMA in this type of list in word:

423.1,
416.8,
416.9,
417.8,
429.4,
429.0,

I have over 1000 in my list and don't want to sit and hit the delete key 1000 times....any help is much appreciated.

Thanks
Avatar of GrahamSkan
GrahamSkan
Flag of United Kingdom of Great Britain and Northern Ireland image

Do Fimnd and REplace:

Find: ^p
Replace: (a space or nothing)

If this doesn't work try Find: ^l (That's a lower case L)
Avatar of Marcus Aurelius

ASKER

Not working.

I'm using Word 2010....any other suggestions?
Show the formatting marks with the Show/Hide button (¶) in the Paragraph group on the Home tab. What character appears at the end of the line?
I can't make a copy to show you here,...but it looks alot like a very tiny "SUN". A slight variation of an asterick "*" but again,..it looks just like an asterick with a small circle in the middle.... a..."SUN" for lack of a better description.....
Avatar of nap0leon
nap0leon

Sounds like you are working in a table and not actually paragraphs.

If so, highlight the entire section and do "Table - Convert - Table to Text"
It sounds as if you have a table.

Select one of the lines and see if 'Table Tools' appears above the ribbon.

If it does, select the Layout tab. Select the dropdown arrow under the 'Select ' button (left end of ribbon) and choose 'Select Table'. Then use the 'Convert to Text' button to open the conversion dialog. Click OK, and you should have a set of paragraphs on which you can do Find: ^p.

If this doesn't work, copy and paste a bit of the text to a new document, and post it here.
Ok,... data was copied FROM Excel spreadsheet column, into WORD to try and remove LINE FEED.

My whole goal is to copy the above listing of over 1000 codes, and paste into a reporting program'sn parameter or condition field. Reporting system is Business Objects. When I use excel and do a copy/paste of the entire 1000 row listing,...ONLY the 1st value pastes.

I've tried copy/paste data inot Notepad...and couldn't find a way to remove the LIFE FEED.

Now I'm in Word trying to find a solution to removing the LINE FEED and making this list ONE BIG LONG LINE OF CODES separated by commas.

So,....YES,...the original data is from an excel spreadsheet....

However it is now in WORD...and so I'd like to see if there is a solution in WORD....???

Hope it makes sense......
Post a small sample document here, please.
Exact same as above...just place an excel CELL around each line below.....not sure what you mean...???

861.32,
861.22,
861.21,
860.5,
860.4,
860.2,
860.1,
860.0,
854.09,
854.06,
854.05,
862.29,
You have pasted something into a Word document. We have not been able to guess exactly how it turns out in that document, so can you post the document here, please, as opposed to pasting the text?

User the File link below the comment box
ASKER CERTIFIED SOLUTION
Avatar of nap0leon
nap0leon

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I found another solutions in EXCEL...but this was the closest solution here...thanks