concatenate expression error

P

philr

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
 
T

Teethless mama

You may have Formulas turn on.

Go to Tools > Optionns > View tab > uncheck Formulas
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top