Excel Formula nth String

%3CLINGO-SUB%20id%3D%22lingo-sub-2695569%22%20slang%3D%22en-US%22%3EExcel%20Formula%20nth%20String%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2695569%22%20slang%3D%22en-US%22%3E%3CP%3ENeed%20Help.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHave%20an%20excel%20file%20with%20a%20column%20that%20has%20an%20equation.%20Essentially%2C%20I%20want%20to%20see%20the%20newest%20payment%20(from%20the%20equation)%20in%20another%20column.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWant%20to%20do%20the%20following%20in%20a%20column%20next%20to%20the%20previous%20one%3A%3C%2FP%3E%3CP%3E1.%20Convert%20a%20formula%20to%20text.%3C%2FP%3E%3CP%3E2.%20If%20only%20one%20number%20(maximum%20length%20%23%23%23%2C%23%23%23.%23%23)%20add%20that%20text%20after%20the%20%22%3D%22%20sign.%3C%2FP%3E%3CP%3E3.%20Every%20time%20add%20a%20number%20to%20the%20equation%2C%20populate%20the%20nth%20string%20to%20this%20secondary%20column.%3C%2FP%3E%3CP%3E4.%20Keep%20repeating%20until%20the%20last%20nth%20string%20is%20placed%20into%20the%20equation.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAttachment%20shows%20what%20trying%20to%20achieve.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20help.%3C%2FP%3E%3CP%3EScott%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2695569%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECommunity%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2699512%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%20nth%20String%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2699512%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1140260%22%20target%3D%22_blank%22%3E%40Scott1417%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHello!%20You've%20posted%20your%20question%20in%20the%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Ftech-community-discussion%2Fbd-p%2FCommunityQuestions%22%20target%3D%22_blank%22%3ETech%26nbsp%3BCommunity%20Discussion%20space%3C%2FA%3E%2C%20which%20is%20intended%20for%20discussion%20around%20the%20Tech%20Community%20website%20itself%2C%20not%20product%20questions.%20I'm%20moving%20your%20question%20to%20the%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2Fbd-p%2FExcelGeneral%22%20target%3D%22_blank%22%3EExcel%20space%3C%2FA%3E%20-%20please%20post%20Excel%20questions%20here%20in%20the%20future.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Need Help. 

 

Have an excel file with a column that has an equation. Essentially, I want to see the newest payment (from the equation) in another column. 

 

Want to do the following in a column next to the previous one:

1. Convert a formula to text.

2. If only one number (maximum length ###,###.##) add that text after the "=" sign.

3. Every time add a number to the equation, populate the nth string to this secondary column.

4. Keep repeating until the last nth string is placed into the equation.

 

Attachment shows what trying to achieve. 

 

Thank you for your help.

Scott

 

1 Reply

@Scott1417 

Hello! You've posted your question in the Tech Community Discussion space, which is intended for discussion around the Tech Community website itself, not product questions. I'm moving your question to the Excel space - please post Excel questions here in the future.