Merge two cells together without losing value of one cell

S

Sharon

Is there any way to merge two cells together without getting one value
deleted? As an example, I'd like to add ";" after a number, but when I do a
merge the ";" would get deleted. Thanks.
 
D

David Heaton

I have 300 cells with numbers to add ";" to.





- Show quoted text -

If you just wish to add the ; to a value in a cell you could use
either
=CONCATENATE(A1,";")
or
=A1 & ";"

hth

Regards

David
 
S

Sharon

Thanks, David. It works!!

David Heaton said:
If you just wish to add the ; to a value in a cell you could use
either
=CONCATENATE(A1,";")
or
=A1 & ";"

hth

Regards

David
 

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