Get Data Before Mark "/" First Then Add "-REV" in Behind

[muhammad susanto]

hi all..

how to get data before mark "/" at first then add "-REV" at behind
this layout

Raw Data	After formula
LPK-3.00035/1/1/WKN.03/KNL.01/01.00/2017	LPK-3.00035-REV
LPK-3.040/1/1/WKN.03/KNL.01/01.00/2017	LPK-3.040-REV
LPK-IV. 00018 /1/1/WKN.03/KNL.01/01.00/2017	LPK-IV. 00018-REV
LPK-2.010/1/1/WKN.03/KNL.01/01.00/2017	etc…

note :
don't use macro/vba

any help thank in advance.
.sst

 

[Eric W]

Try:

Book1
	A	B
1	Raw Data	After formula
2	LPK-3.00035/1/1/WKN.03/KNL.01/01.00/2017	LPK-3.00035-REV
3	LPK-3.040/1/1/WKN.03/KNL.01/01.00/2017	LPK-3.040-REV
4	LPK-IV. 00018 /1/1/WKN.03/KNL.01/01.00/2017	LPK-IV. 00018 -REV
5	LPK-2.010/1/1/WKN.03/KNL.01/01.00/2017	LPK-2.010-REV
Sheet14

Cell Formulas
Range	Formula
B2:B5	B2	=LEFT(A2,FIND("/",A2)-1)&"-REV"

 

[Fluff]

How about

=LEFT(A2,FIND("/",A2)-1)&"-REV"

 

[muhammad susanto]

hi guys worked well..
thank you so much!!

 

[Fluff]

Glad we could help & thanks for the feedback.