re: Help Excel gurus..need to automatically reformat a text string

No need to do anything manual - the right formulas with the correct cell references should give you what you need when you copy down the 10,000 rows.

You know you can build a text string via formula with text strings in quotes or cell references seperated by the & symbol right?

For example lets assume cell a1 has the sting "excel" and cell b1 has string "easy".

=a1&"is"&b2 would give you "excel is easy"



Therefore all you need to do is isolate all your text strings with find and mid then build them back together with a function like the above.