Hello,
How can I remove the last + from end of each keyword?
Basically I want to remove any empty space and or the very last + or multiple +'s
See attached sheet for example:
Example:
Currently it is: +ab +cd +efg +
Desired Result: +ab +cd +efg
Currently it is: +abs +def + +
Desired Result: +abs +def
Currently it is: [ab cd ]
Desired Result: [ab cd]
Currently it is: [ab cd ef ]
Desired Result: Currently it is: [ab cd ef]
etc.
Thanks
Try this
Enter im B2 and copy down
Formula:
=IF(ISNUMBER(FIND("[",A2)),A2,TRIM(SUBSTITUTE(" "&TRIM(SUBSTITUTE(C2,"+"," "))," "," +")))
v A B 1 KWD 2 +ab +cd +efg + +ab +cd +efg 3 +abs +def + + +abs +def 4 +absch +fegh + ++ +absch +fegh 5 +absch +fegh +ghi ++ +absch +fegh +ghi 6 +abc +++ +abc 7 [ab cd ] [ab cd ] 8 [ab cd ef ] [ab cd ef ]
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
I thought the OP wanted to make the " ]" a "]".
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Hey Vegas,
Put this in B2 and pull it down
Removing Last +Test.xlsx
=IF(LEFT(A2,1)="+",SUBSTITUTE(TRIM(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2, " +", " ")," +"," ")," +"," "))," "," +"),SUBSTITUTE(A2," ]","]"))
Last edited by MarvinP; 04-18-2017 at 08:02 PM.
With minor correction
Formula:=IF(ISNUMBER(FIND("[",A2)),SUBSTITUTE(A2," ]","]"),TRIM(SUBSTITUTE(" "&TRIM(SUBSTITUTE(C2,"+"," "))," "," +")))
v A B 1 KWD 2 +ab +cd +efg + +ab +cd +efg 3 +abs +def + + +abs +def 4 +absch +fegh + ++ +absch +fegh 5 +absch +fegh +ghi ++ +absch +fegh +ghi 6 +abc +++ +abc 7 [ab cd ] [ab cd] 8 [ab cd ef ] [ab cd ef]
Thank You All. AllKey you're formula worked perfectly.
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks