K klunshada New Member Joined Jun 13, 2003 Messages 17 Dec 1, 2005 #1 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.
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 MrExcel MVP Joined Feb 10, 2002 Messages 2,330 Dec 1, 2005 #2 Does this work for you? =PROPER(B1&" "&RIGHT(A1,LEN(A1)-FIND(" ",A1)))
ChrisUK Well-known Member Joined Sep 3, 2002 Messages 675 Dec 1, 2005 #3 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 ?
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 ?