LinkBack URL
About LinkBacks
Hi,
I have a column of text. I need to seperate this column in two columns, one holding just the last word and the other holding all the other string.
How is theat possible?
Thank you in advance
Hi,
I have a column of text. I need to seperate this column in two columns, one holding just the last word and the other holding all the other string.
How is theat possible?
Thank you in advance
Do you have some sample data that you can show?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Try these
B1: =LEFT(A1,FIND(CHAR(1),SUBSTITUTE(A1," ",CHAR(1),LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))-1)
C1: =SUBSTITUTE(A1,B1&" ","")
Hi,
B1 is giving a True answer.
Should it be the answer?
What is in A1?
The text the I want to seperate.
I know that, I ask what that value is that returns TRUE.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks