Copy from merge cell

M

MK

When I copy (Cell B2) from a merge cell for example A1 to S1 the result is
#########
When I delete the range and copy from A1 it work, but when merge cell (A1 to
S1) is blank "0" appear is B2.
How to get rid of the "O"
 
D

Dave Peterson

Try formatting that receiving cell (B2?) as General.

Cells formatted as Text have problems when the length of the string is between
255 and 1024.
 
M

MK

Dave Peterson said:
Try formatting that receiving cell (B2?) as General.

Cells formatted as Text have problems when the length of the string is between
255 and 1024.

MK wrote:
Click to expand...
Dave it doesn't work, the "0" still appear. Thanks for your help anyway.
Anyone out there can help?
Thanks for your help in advance.....MK
 
D

Dave Peterson

Are you copying and pasting or are you using a formula that returns the value in
A1?

If your formula looks like:

=a1
make it look more like:
=if(a1="","",a1)

I'm kind of confused at what you're doing.

If you don't get a better response, you may want to rephrase your question.
 
M

MK

Yes got it, thank you very much

Dave Peterson said:
Are you copying and pasting or are you using a formula that returns the value in
A1?

If your formula looks like:

=a1
make it look more like:
=if(a1="","",a1)

I'm kind of confused at what you're doing.

If you don't get a better response, you may want to rephrase your question.
Click to expand...
 
Top