I want to move text thats in the middle of the cell to the begining of
the cell...

Cell A1 Reads "DANIEL & BETTINA SMITH ACCOUNT INFO"

Cell B1 reads "SMITH"


Ex. Using cell B1, take the text "SMITH" and move it to the front of
the text string while deleting the other "SMITH" in the middle...
"SMITH, DANIEL & BETTINA SMITH ACCOUNT INFO"

I want cell A1 or C1 to look like this "SMITH, DANIEL & BETTINA ACCOUNT
INFO"

is this possible???


--
azazel
------------------------------------------------------------------------
azazel's Profile: http://www.excelforum.com/member.php...o&userid=28250
View this thread: http://www.excelforum.com/showthread...hreadid=482849

This equation requires a space character to be found after the string in B1...
=IF(ISNUMBER(FIND(B1&" ",A1)),B1&",
"&LEFT(A1,FIND(B1,A1)-1)&RIGHT(A1,LEN(A1)-LEN(B1)-FIND(B1,A1)),A1)
--Bruce


"azazel" wrote:


I want to move text thats in the middle of the cell to the begining of
the cell...

Cell A1 Reads "DANIEL & BETTINA SMITH ACCOUNT INFO"

Cell B1 reads "SMITH"


Ex. Using cell B1, take the text "SMITH" and move it to the front of
the text string while deleting the other "SMITH" in the middle...
"SMITH, DANIEL & BETTINA SMITH ACCOUNT INFO"

I want cell A1 or C1 to look like this "SMITH, DANIEL & BETTINA ACCOUNT
INFO"

is this possible???


--
azazel
------------------------------------------------------------------------
azazel's Profile: http://www.excelforum.com/member.php...o&userid=28250
View this thread: http://www.excelforum.com/showthread...hreadid=482849