IMPLEMENT: In Column A We Just Need To Paste The Comma Separated Text And Apply The Formula In Column B – C – D – E – F As Mentioned Below. Once The Formula Is Applied You It Will Automatically Separate Text To Columns. Please Check Formula & Notes & Image Below.
NOTE: Please Change The Reference If You Want To Apply On Different Range. Also If you Have Space Separated Text You Can Change Replace The Comma With Space And It Will Work For You. You Can Replace Any Character.
NOTE: This Formula Works For 5 Comma Separated Text Only. But By Editing The Formula It Is Possible To Increase For More Text.
TO GET ALL SEPARATED TEXT IN SINGLE CELL FORMULA:
