Home » Blogs » EricMoorhead's blog

Excel CONCATENATE

Submitted by EricMoorhead on 14 September, 2012 - 18:50

I applied this formula =CONCATENATE(A1"-"B1) to a spread sheet of mine and now I need to get rid of the cells that were merged from. How do I do this with out loosing the new data in the merged cell???

»

Follow this steps

Submitted by manny on 14 September, 2012 - 23:14.

Hi,

Follow this steps: select new data -> Copy -> Paste Values -> delete unnecessary data.

When you paste data you can paste them in the same range or another one.

 

Best regards.

»