Hi,

I am new to this forum and have been trying to figure out to question
for a long time. I would really appreciate anyones response tha
understands excel very well.

Question 1) I work on excel alot and while editing the sheet, the row
the text gets wrapped once i leave the cell. I have to "format" th
cells and click unwrap the text to make it unwrap. How do i stop th
sheet from automatically wrapping the text while I do make changes t
the excel sheet. I often work on an excel sheet CSV file?

Question 2) I usually use the "replace" function while working on th
same sheet. Lately when i tried to use the find and replace bar it wil
not work. It gives me an error that "The forumla is too long" Doe
anyone know what that means and how I could get the replace function t
work properly across the entire excel sheet? I appreciate any help.

Thanks
Mitch
www.onewayfurniture.co

--
Message posted from http://www.ExcelForum.com

2. Your formula is too long. Try changing to defined names to drastically
shorten. Or, copy/paste an example.
Send my leather recliner to the address below.

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"furnitureday >" <<(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
> Hi,
>
> I am new to this forum and have been trying to figure out to questions
> for a long time. I would really appreciate anyones response that
> understands excel very well.
>
> Question 1) I work on excel alot and while editing the sheet, the rows
> the text gets wrapped once i leave the cell. I have to "format" the
> cells and click unwrap the text to make it unwrap. How do i stop the
> sheet from automatically wrapping the text while I do make changes to
> the excel sheet. I often work on an excel sheet CSV file?
>
> Question 2) I usually use the "replace" function while working on the
> same sheet. Lately when i tried to use the find and replace bar it will
> not work. It gives me an error that "The forumla is too long" Does
> anyone know what that means and how I could get the replace function to
> work properly across the entire excel sheet? I appreciate any help.
>
> Thanks
> Mitch
> www.onewayfurniture.com
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>

Don,
Please let us know when it arrives. <g>
Regards,
Jim Cone
San Francisco, Ca

"Don Guillett" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> 2. Your formula is too long. Try changing to defined names to drastically
> shorten. Or, copy/paste an example.
> Send my leather recliner to the address below.
> Don Guillett
> SalesAid Software

> (E-Mail Removed) "furnitureday >" <<(E-Mail Removed)
> wrote in message news:(E-Mail Removed)...
> > Hi,
> > I am new to this forum and have been trying to figure out to questions
> > for a long time. I would really appreciate anyones response that
> > understands excel very well.
> > Question 1) I work on excel alot and while editing the sheet, the rows
> > the text gets wrapped once i leave the cell. I have to "format" the
> > cells and click unwrap the text to make it unwrap. How do i stop the
> > sheet from automatically wrapping the text while I do make changes to
> > the excel sheet. I often work on an excel sheet CSV file?
> > Question 2) I usually use the "replace" function while working on the
> > same sheet. Lately when i tried to use the find and replace bar it will
> > not work. It gives me an error that "The forumla is too long" Does
> > anyone know what that means and how I could get the replace function to
> > work properly across the entire excel sheet? I appreciate any help.
> > Thanks
> > Mitch
> > www.onewayfurniture.com