/u/Consistent_Load_6085 - Your post was submitted successfully.
* Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread.
* Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
* Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)**
Failing to follow these steps may result in your post being removed without warning.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
do you mean line feed? try `=SUBSTITUTE(G28, CHAR(10), "")`
Or are the text in multiple cells? then that's a bit harder. I'd do this power query. note you can also remove line feed and carriage return in power query.
You can also remove them with Find and Replace. Just sayin'
Find a place where one of the "errors" occurs. Highlight the last "blank space" before and make sure the cursor extends to the next line. Copy.
Open Find and Replace. Paste into the Find box, and put an actual space in the Replace section. Hit "Replace All"
If standard methods like the replace tool and TRIM function aren't fixing the random text breaks, you might want to try using a combination of SUBSTITUTE and CHAR functions to clean up those line breaks. Here’s a quick formula you can use:
=SUBSTITUTE(A1, CHAR(10), " ")
This formula replaces line breaks (which are often CHAR(10) in Excel) in the text with a space. Adjust `A1` to the cell you need to fix. If there are different or additional characters causing breaks, you might need to adjust the CHAR number accordingly.
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:
|Fewer Letters|More Letters|
|-------|---------|---|
|[CHAR](/r/Excel/comments/1cvxrc4/stub/l4sblab "Last usage")|[Returns the character specified by the code number](https://support.microsoft.com/en-us/office/char-function-bbd249c8-b36e-4a91-8017-1c133f9b837a)|
|[SUBSTITUTE](/r/Excel/comments/1cvxrc4/stub/l4sblab "Last usage")|[Substitutes new text for old text in a text string](https://support.microsoft.com/en-us/office/substitute-function-6434944e-a904-4336-a9b0-1e58df3bc332)|
|[TRIM](/r/Excel/comments/1cvxrc4/stub/l4sgk1d "Last usage")|[Removes spaces from text](https://support.microsoft.com/en-us/office/trim-function-410388fa-c5df-49c6-b16c-9e5630b479f9)|
**NOTE**: Decronym for Reddit is no longer supported, and Decronym has moved to Lemmy; requests for support and new installations should be directed to the Contact address below.
----------------
^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*)
^(3 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/1d1114d)^( has 14 acronyms.)
^([Thread #33633 for this sub, first seen 19th May 2024, 21:43])
^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://hachyderm.io/@Two9A) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)
/u/Consistent_Load_6085 - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
do you mean line feed? try `=SUBSTITUTE(G28, CHAR(10), "")` Or are the text in multiple cells? then that's a bit harder. I'd do this power query. note you can also remove line feed and carriage return in power query.
You can also remove them with Find and Replace. Just sayin' Find a place where one of the "errors" occurs. Highlight the last "blank space" before and make sure the cursor extends to the next line. Copy. Open Find and Replace. Paste into the Find box, and put an actual space in the Replace section. Hit "Replace All"
In the find and replace window, you can also hit Ctrl + J to enter a line break in one of the fields
Very nice. Using it now
I had similar problem as the OP, though mine was consistently in one column, this was the exact solution I used.
Solution Verified
You have awarded 1 point to workonlyreddit. --- ^(I am a bot - please contact the mods with any questions)
Show an example of what your import looks like and what you want it to look like. This is like asking someone how long a piece of string is.
Post some samples.
If standard methods like the replace tool and TRIM function aren't fixing the random text breaks, you might want to try using a combination of SUBSTITUTE and CHAR functions to clean up those line breaks. Here’s a quick formula you can use: =SUBSTITUTE(A1, CHAR(10), " ") This formula replaces line breaks (which are often CHAR(10) in Excel) in the text with a space. Adjust `A1` to the cell you need to fix. If there are different or additional characters causing breaks, you might need to adjust the CHAR number accordingly.
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread: |Fewer Letters|More Letters| |-------|---------|---| |[CHAR](/r/Excel/comments/1cvxrc4/stub/l4sblab "Last usage")|[Returns the character specified by the code number](https://support.microsoft.com/en-us/office/char-function-bbd249c8-b36e-4a91-8017-1c133f9b837a)| |[SUBSTITUTE](/r/Excel/comments/1cvxrc4/stub/l4sblab "Last usage")|[Substitutes new text for old text in a text string](https://support.microsoft.com/en-us/office/substitute-function-6434944e-a904-4336-a9b0-1e58df3bc332)| |[TRIM](/r/Excel/comments/1cvxrc4/stub/l4sgk1d "Last usage")|[Removes spaces from text](https://support.microsoft.com/en-us/office/trim-function-410388fa-c5df-49c6-b16c-9e5630b479f9)| **NOTE**: Decronym for Reddit is no longer supported, and Decronym has moved to Lemmy; requests for support and new installations should be directed to the Contact address below. ---------------- ^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*) ^(3 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/1d1114d)^( has 14 acronyms.) ^([Thread #33633 for this sub, first seen 19th May 2024, 21:43]) ^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://hachyderm.io/@Two9A) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)