LinkBack URL
About LinkBacks
Dear all, I have having data in the cell A1:A , need to separate the data in the cell B1:B as below
Here I have added also the text “:Signaling”
Please Login or Register to view this content.
Dear all, I have having data in the cell A1:A , need to separate the data in the cell B1:B as below
Here I have added also the text “:Signaling”Please Login or Register to view this content.
Last edited by nur2544; 10-03-2014 at 10:22 AM.
And your question is???
Try this
=TRIM(LEFT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"-"," "),"_"," ")," ",REPT(" ",25)),25))&" "&":Signaling"
BSE22-0 BSE22 :Signaling MGW14 MGW14 :Signaling MGW14 MGW14 :Signaling BSE41 HSL BSE41 :Signaling
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Hi AlKey, Yes it works perfectly ! , i appreciated it , thanks for your valuable time..
You're welcome and thank you for the feedback!
Will this work for you?
=IFERROR(LEFT(A1,FIND("-",SUBSTITUTE(SUBSTITUTE(A1," ","-"),"_","-"),1)-1),A1)&" :Signaling"
oops should have refreshed lol
edit: AlKey, that last part can be shorted by including the space with the text...
&" :Signaling"
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
Register To Reply
Bookmarks