હિમાંશુ પરભુભાઇ મિસ્ત્રી | Himanshu Mistry

મે 7, 2008

searching for Linebreaks inside a cell MS Excel

Filed under: Uncategorized — Himanshubhai Mistry @ 4:07 pm

Searching for Line breaks inside a cell MS Excel

Sometimes you will find a line break (new paragraph/line) inside a cell in Excel.
And if you need to remove all unnecessary line breaks in a sheet.

To find and replace in Excel, you can use “Alt+0010” inside the Find & Replace box.
You will not see anything in Excel’s F&R box, but the code is there.
You can replace all line breaks with either a space or nothing.

I found this tip/trick on http://www.necco.ca/dv/ppt_excel.htm

 I will upload some screenshots also after some time.

 

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: