Extracting data from within a formula ?

[wisemank]

Here is a sample of an equation with text embedded. I want to extract and string with comma separation between all "" marks... Example from below would be: Drum in Hat Park Brake, Rear Rotor, DRW Rear Hub...etc. (THOUGHTS???)

---

=1300000+N("Drum in Hat Park Brake")+300000+N(" Rear Rotor")+300000+N("DRW Rear Hub")+200000+N("Wheel Speed Sensor")+50000+N("Park Brake Cable")+400000+N("Rear Brake Hose / Tubes")+500000+N("Rear Caliper Anchor Brakt")+300000+N("Frt Extender")+N("All Investment to achieve capability to 46k")

---

 

[robertdseals]

This isn't pretty and might not work, but might give someone a direction to go.
If you put a ' in front of your formula, it will turn it to text '=1300000+N("Drum....
Let's say that is in cell A1
Then in A2 you put =FIND("+N",A1)
In B2 you put =RIGHT(A1,LEN(A1)-A2-3)
You copy those down until you get to the end, then you do a left() using each of those and use a find(" to determine how many spaces you need.
Like I said, not pretty. Hopefully someone can come up with something better. This isn't pretty and might not work, but might give someone a direction to go.
If you put a ' in front of your formula, it will turn it to text '=1300000+N("Drum....
Let's say that is in cell A1
Then in A2 you put =FIND("+N",A1)
In B2 you put =RIGHT(A1,LEN(A1)-A2-3)
You copy those down until you get to the end, then you do a left() using each of those and use a find(" to determine how many spaces you need.
Like I said, not pretty. Hopefully someone can come up with something better.

 

[robertdseals]

This also looks like a good start (instead of putting the ' before the formula).
How to convert formula to text string in Excel?