Merge two cells together without losing value of one cell

  • Thread starter Thread starter Sharon
  • Start date Start date
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.
 
I have 300 cells with numbers to add ";" to.





- Show quoted text -
Click to expand...

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

hth

Regards

David
 
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
Click to expand...
 
Back
Top