How To Split Text From A Cell Range Into Different Columns Using Formula
In this case, I want to extract each line of the cell into a seperate column
Example - Cell A1 Reads:
Company: Mid Atlantic Industrial Equipment LTD
Market: Harrisburg,PA
Company Size: upto15000+
Industry: Automotive-Sales-and-Repair-Services
Company's Career Page: http://www.midatlanticindustrial.com/e"
Would like each line to be seperate column with no header such as just "Mid Atlantic Industrial Equipment LTD" in A1, "Harrisburg,PA" in C1 etc.
Can anyone help? Thanks very much in advance.
khadder, welcome to ExcelFox community.
You can do this using some text functions like LEFT, MID, SUBSTITUTE etc. Check the attached file, and let me know if that's what you needed.
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
Posting Permissions
Reply With Quote
Bookmarks