LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 397
Default Find and Replace alt enter


Howdie,

I have a column on which the first line of each cell is the "alt enter"
symbol (ie detail starts on second line within a cell). How do I find
that alt enter charachter and replae it with nothing (ie moving the
second line of text up to the first line of text) within each cell?

Regards
D

*** Sent via Developersdex http://www.developersdex.com ***
 
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
Find and Replace - Replace with Blank Space Studebaker Excel Discussion (Misc queries) 4 April 3rd 23 10:55 AM
Find/Replace Event or Find/Replace for Protected Sheet ... Joe HM Excel Programming 2 October 27th 07 03:55 PM
Find based on cond. 4matting? Replace as ALT-Enter? (2 diff prob HopefulTraveller Excel Discussion (Misc queries) 7 May 18th 07 05:54 PM
find and replace - replace data in rows to separated by commas msdker Excel Worksheet Functions 1 April 15th 06 01:00 AM
replace 'alt + enter' key by single 'enter' Gerson Setting up and Configuration of Excel 3 February 6th 06 03:00 AM


All times are GMT +1. The time now is 04:03 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"