Combining Cells

[klunshada]

Hi All,

I have 2 cells.

Cell A is ak anchorage
Cell B is Health insurance In

I want cell C to be Health Insurance In Anchorage

What formula would that be? Including changing anchorage to Anchorage.

Thanks as always.

 

[Barrie Davidson]

Does this work for you?

=PROPER(B1&" "&RIGHT(A1,LEN(A1)-FIND(" ",A1)))

 

[ChrisUK]

Try this in cell C (assuming row 1)

=A1&" "&B1

if A1 = anchorage and B1 = Health Insurance in" then C1 = Health Insurance in anchorage"

Is this what you're after ?