concatenate 4 rows...

  • Thread starter Thread starter David
  • Start date Start date
D

David

I need to concatenate A1,B1,C1,D1 into >>> E1 , am using the formula;

=CONCATENATE(A1,B1,C1,D1)

pasted in E1, all I get is the formula, not the concatenation, what gives
???

Thanks David
 
See if it is formatted as text, format as general, then do edit>replace and
replace
= with = (yes in the find what put the equal sign and in the replace with
put the equal sign)
Many times that will force the formula to be calculated
 
thanks, that worked...



Peo Sjoblom said:
See if it is formatted as text, format as general, then do edit>replace and
replace
= with = (yes in the find what put the equal sign and in the replace with
put the equal sign)
Many times that will force the formula to be calculated

--

Regards,

Peo Sjoblom
 

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

Back
Top