Break text
hello i need some help. in COLUMN A i have text in one cell i need break this text in two cell COLUMN B and COLUMN C
COLUMN A COLUMN B COLUMN C PERSPO0112 -1 | PERSPO0112 | -1 PERSPO0133 1 | PERSPO0133 | 1 PERSPO0132 -1 | PERSPO0132 | -1 PP07010024 -8 | PP07010024 | -8 PP07010361 -4 | PP07010361 | -4 PP07010531 -1 | PP07010531 | -1 PP07010624 -4 | PP07010624 | -4 PR01010014 -4436,063 | PR01010014 | -4436,063 SOF200639 2 | SOF200639 | 2
If your data starts in A2 paste the below codes and drag down.
Paste in B2 to keep everything before the space:
Formula:
=LEFT(A2,FIND(" ",A2)-1)
Paste in C2 to keep everything after the space:
Formula:=RIGHT(A2,LEN(A2)-FIND(" ",A2))
Last edited by playaller; 05-03-2014 at 05:31 PM.
Shelton A.
If Helpful, Add Reputaion!
2 other options...
Option 1
=LEFT(A1,SEARCH(" ",A1,1)-1)
and
=MID(A1,SEARCH(" ",A1,1)+1,99)
Option 2
Use Text2Columns with space as the delimiter
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
arn0ldas 
Register To Reply
Bookmarks