Related Posts
How is AT&T project in Techmahindra?
More Posts
What’s the inside scoop

Is it True

Additional Posts in Excel Genius
Anyone know what these badges are?

New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.






Use find and replace function and replace the arrays with what you want. Or use the formulatext function value paste the results change it with left middle right functions and use that as a formula. Or use VBA but that will take much more time than these first two options.
Thanks, gonna try now!