Forumula Result Good, but circular reference prevents application. Revision?
Trying to change names in a guest list all in the same column. Example: John Doe--->Doe, John.
This is the formula: =MID(A1,FIND(" ",A1,1)+1,LEN(A1)) & ", " & LEFT(A1,FIND(" ",A1))
Like I said the formula result lists exactly what I want but then the Circular Reference warning pops up and then prevents the desired result from occurring...any ideas??
I just tried your formula on a blank workbook and got no circ error. plz note that circ error refferences are not always where excel says they are, and that sometimes it takes a little more digging to find the culprit.
try deleting (and then putting back) different parts of your sheet/book until it disappears, to aid in finding it
there is nothing wrong with the formula you posted tho
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks