concatenate expression error
 

I'm trying to add several fields together into a single cell to import into
another application where there will be line breaks

I have tried the following formula in several different ways.
=CONCATENATE(TEXT(I2, "mm/dd/yyyy"),CHAR(10),"MRN: ",A2,CHAR(10),"Dx: ",J2)

In the above example the cell is formatted as General and when I go to
Format Cell Format Cells Dialog Box shows the correct format (without the
Line Breaks) in the sample section.

My problem is in the cell it only shows the formula itself not the final
expression as I want it. Wrap Text is checked.

Thx,
philr

concatenate expression error
 

You may have Formulas turn on.

Go to Tools Optionns View tab uncheck Formulas


"philr" wrote:

I'm trying to add several fields together into a single cell to import into
another application where there will be line breaks

I have tried the following formula in several different ways.
=CONCATENATE(TEXT(I2, "mm/dd/yyyy"),CHAR(10),"MRN: ",A2,CHAR(10),"Dx: ",J2)

In the above example the cell is formatted as General and when I go to
Format Cell Format Cells Dialog Box shows the correct format (without the
Line Breaks) in the sample section.

My problem is in the cell it only shows the formula itself not the final
expression as I want it. Wrap Text is checked.

Thx,
philr

concatenate expression error
 

change the cell format to 'General'.

I think this should work.
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post! as an ANSWER!


"philr" wrote:

I'm trying to add several fields together into a single cell to import into
another application where there will be line breaks

I have tried the following formula in several different ways.
=CONCATENATE(TEXT(I2, "mm/dd/yyyy"),CHAR(10),"MRN: ",A2,CHAR(10),"Dx: ",J2)

In the above example the cell is formatted as General and when I go to
Format Cell Format Cells Dialog Box shows the correct format (without the
Line Breaks) in the sample section.

My problem is in the cell it only shows the formula itself not the final
expression as I want it. Wrap Text is checked.

Thx,
philr