Excel Power Tips - Merge Text (Concantenate) from Two Cells in MS Excel

[satori2012]

@alfred4utube: You need to detect and eliminate circular references. Excel can do this for you. Just go to "Formulas" tab, then "Formula Auditing", then "Error Checking" and select "Circular References." Click first cell listed on the sub-menu that comes up. If you can't tell whether that cell is the cause, click on the next cell listed in the sub-menu. Remember, the goal is to remove any situations whereby Cell A refers to Cell B that in turn refers back to Cell A. Good luck!

[alfred4utube]

Satori, I need to link a sell on different sheets, but it will be customers names, and i try to = + select the cell but it telling me that it's a circular formula or something like that, can you help me out.