Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 54
Default Undo ALT+ENTER (line breaks inside cells)

How can I undo line breaks that were entered in cells using ALT+ENTER?
Thank you!
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default Undo ALT+ENTER (line breaks inside cells)

Like change them to spaces?

Select the range to fix
edit|replace
what: (ctrl-j)
with: (space bar)
replace all



Filo wrote:

How can I undo line breaks that were entered in cells using ALT+ENTER?
Thank you!


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 54
Default Undo ALT+ENTER (line breaks inside cells)

It worked. Thank you!

"Dave Peterson" wrote:

Like change them to spaces?

Select the range to fix
edit|replace
what: (ctrl-j)
with: (space bar)
replace all



Filo wrote:

How can I undo line breaks that were entered in cells using ALT+ENTER?
Thank you!


--

Dave Peterson

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Alt-Enter Line Breaks Keven Denen Excel Discussion (Misc queries) 2 October 7th 09 04:37 PM
how do I remove line breaks from several cells? JR Excel Discussion (Misc queries) 3 May 15th 09 03:20 AM
Line Breaks in cells - Mac OS X Leopard plunkettphoto Excel Discussion (Misc queries) 1 August 7th 08 08:34 PM
Line breaks in my cells... AkelA Excel Discussion (Misc queries) 3 October 3rd 07 07:18 PM
Remove Line Breaks ALT + ENTER Highman Excel Worksheet Functions 4 April 26th 05 09:25 PM


All times are GMT +1. The time now is 01:43 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"