Help with excel? Formatting a a cell with more than one line.?

Question

How do I remove a blank line at the beginning of the data in a cell? How do I do it quickly for many cells?

I run into a problem often where I have a block of text, with Carriage Returns in them, and I need to change the formatting of 30 to 500 (to 1000) cells quickly.

The main problem is that the first line is a blank line, and I want to remove it in all of the selected cells quickly.

Any ideas?

Answer 1

http://office.microsoft.com/en-us/excel/HP030561311033.aspx



free trial: http://www.sobolsoft.com/excelremove/



macro: http://www.mvps.org/dmcritchie/excel/join.htm#trimall



the easiest way that i could think of is to save the data you want to another format like csv or prn and then edit it using a programmers editor that supports regular expressions. ignore what i just said if it sounds too advanced.

Answer 2

while you're entering into the information by ability of hand, merely press ALT+Enter whenever you desire to start up a clean line interior the cellular. 2 (ALT+Enter)s will go away a clean line. in case you have a formula, or there is already documents there which you extremely choose for to format with clean strains, i do no longer think of this is carried out. Even the ASAP utilities would not enable that one.

Answer 3

Use Word to open the block of text. Use search and replace from word before importing into Excel.

Answer 4

well i am not an excel expert :(



try this site www.excelgoodies.com , there are excel consultants online out there to help you with ur excel questions..