Text moving

A

azazel

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???
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMPRODUCT formula I think w/ wild card & number vs number as text 8
parsing a full name out into Last, First, Middle 2
Show just middle info of a cell 5
Excel Linking Multiple cells to One cell for Results 0
Trim a cell that has names and address to only show name 8
formula that strips the first letter of the first name in a cell 5
Setting format properties when opening Worksheet 1
Subtract text in one cell from another? 3

Top