Welcome Guest ( Log In | Register )

Outline · [ Standard ] · Linear+

 Excel - changing format multiple row to single row

views
     
TSnorhisham
post Nov 26 2022, 04:56 PM, updated 2y ago

New Member
*
Junior Member
23 posts

Joined: Jul 2009
user posted image

Hey guys, how do you change the contents of a cell (eg D13) from multiple rows to a single row?
Thanks.
oimeng
post Nov 26 2022, 05:02 PM

Getting Started
**
Junior Member
76 posts

Joined: Apr 2008
https://www.ablebits.com/office-addins-blog...-returns-excel/
alexander3133
post Nov 26 2022, 05:44 PM

Regular
******
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.
Takudan
post Nov 26 2022, 06:41 PM

Enthusiast
*****
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
WH4CockcooBird
post Nov 26 2022, 06:47 PM

Getting Started
**
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.
TSnorhisham
post Nov 27 2022, 02:49 PM

New Member
*
Junior Member
23 posts

Joined: Jul 2009
Thanks guys rclxms.gif

Find and Replace Ctrl J did the trick.

WH4CockcooBird
post Nov 27 2022, 05:44 PM

Getting Started
**
Junior Member
173 posts

Joined: Jul 2022
QUOTE(norhisham @ Nov 27 2022, 02:49 PM)
Thanks guys  rclxms.gif

Find and Replace Ctrl J did the trick.
*
Weird shit they do but it works eh....

biggrin.gif biggrin.gif biggrin.gif

 

Change to:
| Lo-Fi Version
0.0130sec    0.45    5 queries    GZIP Disabled
Time is now: 29th March 2024 - 11:35 PM