Multiple text to 2 columns
Closed
Bruce427
-
Apr 17, 2010 at 07:20 AM
rizvisa1
rizvisa1
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Related:
- Multiple text to 2 columns
- Excel data validation list show 2 columns - Guide
- Excel - Extract a list from 2 columns - How-To - Excel
- Excel formula to find matching text in 2 columns - Guide
- Split data into multiple workbooks based on column with vba code - Guide
- Compare the words in 2 columns in Excel ✓ - Forum - Excel
1 reply
rizvisa1
Apr 17, 2010 at 07:51 AM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Apr 17, 2010 at 07:51 AM
If your data is in cell A1 and first word is to be on cell b1 and rest in c1 then in B1 use this
=IF(ISERROR(FIND(" ",A1,1)), A1, LEFT(A4,FIND(" ",A1,1)-1))
and in C1 use
=IF(ISERROR(FIND(" ",A1,1)), "", MID(A1,FIND(" ",A1,1)+1,LEN(A1)))
=IF(ISERROR(FIND(" ",A1,1)), A1, LEFT(A4,FIND(" ",A1,1)-1))
and in C1 use
=IF(ISERROR(FIND(" ",A1,1)), "", MID(A1,FIND(" ",A1,1)+1,LEN(A1)))