Combining Cells

[hammer2]

Hi,

Column A cell 2 has a value...lets say 2
Column B cell 2 has text..lets say 'High Dependency'
Is there a means to combine the 2 cells into Column C cell 2 to read '2. High Dependancy' ?

Thats 2dot space High Dependency

I have hundreds of cells so hope there is a way to do this rather than have to do each manually.

Thanks
Hammer

[Miraun]

Yep, in Column C, use =A2&". "&B2

Afterwards, since this equation references columns A and B, you'll need to copy and then do a paste special
Paste just the values

That way you can move the information to other worksheets as needed, without the backend equations.

[hammer2]

hehehe..beautiful!!

Thanks so much Miraun.