Excel - changing format multiple row to single row
Excel - changing format multiple row to single row
|
Nov 26 2022, 04:56 PM, updated 2y ago
Show posts by this member only | Post
#1
|
Junior Member
23 posts Joined: Jul 2009 |
|
|
|
|
Nov 26 2022, 05:02 PM
Show posts by this member only | Post
#2
|
Junior Member
76 posts Joined: Apr 2008 |
|
|
Nov 26 2022, 05:44 PM
Show posts by this member only | Post
#3
|
Senior Member
1,649 posts Joined: May 2006 From: JDT |
Try either "Shift + Enter" or "Ctrl + Enter" on the new sentence, can't remember which.
|
|
Nov 26 2022, 06:41 PM
Show posts by this member only | IPv6 | Post
#4
|
Junior Member
834 posts Joined: Jun 2011 From: Kuala Lumpur, Malaysia |
A line break is a CODE CHA R( 10 ) You can try this formula to convert, e.g. cell E13 equals to CODE = SUBSTITUTE(D13, CHA R( 10 ), " ") This will replace the line breaks with a space. Put "" if you want it to be removed without replacement. Note: "CHAR" not cha r, cloudflare blocked me from writing it outright due to security reasons I guess 6942nole liked this post
|
|
Nov 26 2022, 06:47 PM
Show posts by this member only | IPv6 | Post
#5
|
Junior Member
173 posts Joined: Jul 2022 |
First reply above is correct..
Find and Replace. CTRL-J key stroke in "Find" section, something will blink there Left Replace section blank Click replace all. |
|
Nov 27 2022, 02:49 PM
Show posts by this member only | Post
#6
|
Junior Member
23 posts Joined: Jul 2009 |
Thanks guys Find and Replace Ctrl J did the trick. WH4CockcooBird liked this post
|
|
Nov 27 2022, 05:44 PM
Show posts by this member only | IPv6 | Post
#7
|
Junior Member
173 posts Joined: Jul 2022 |
|
Change to: | 0.0130sec
0.45
5 queries
GZIP Disabled
Time is now: 29th March 2024 - 11:35 PM |