Combining Cells

klunshada

New Member
Joined
Jun 13, 2003
Messages
17
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.
 

Some videos you may like

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

ChrisUK

Well-known Member
Joined
Sep 3, 2002
Messages
675
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 ?
 

Watch MrExcel Video

Forum statistics

Threads
1,118,169
Messages
5,570,654
Members
412,335
Latest member
cinciri99
Top