Split Comma Separated Text With Formula In Excel
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.
DOWNLOAD FORMULA FILE HERE ===>Download
TO GET ALL SEPARATED TEXT IN SINGLE CELL FORMULA:
COPY THE FORMULA : CHECK AT LASTDownload