i want to get the following text into seperate columns in the same row. the string has to start with the digits.kindly see the attached.
i want to get the following text into seperate columns in the same row. the string has to start with the digits.kindly see the attached.
using helper column
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
=TRIM(MID($B$2,IFERROR(FIND(ROWS($B$7:$B7)&" ",$B$2),(9^9)),IFERROR(FIND(ROWS($B$7:$B7)+1&" ",$B$2),(9^9))-IFERROR(FIND(ROWS($B$7:$B7)&" ",$B$2),(9^9))))
Try this in "B7" and copy towards down
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
=TRIM(MID($B$2,IFERROR(FIND(ROW(1:1)&" ",$B$2),(9^9)),IFERROR(FIND(ROW(2:2)&" ",$B$2),(9^9))-IFERROR(FIND(ROW(1:1)&" ",$B$2),(9^9))))
can try this to
and copy towards down
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
Thanks for your feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks