Remove Text in Cust. Codes

[Navi_G]

Dear Experts,

Please check i need to remove text like....

Remove
AVA
AVB
AVC
AWA
AWB


Please resolve this issue....

[jeffreybrown]

Navi_G,

It's always a good idea to present us with what you want the results to look like...

For starters, try in C2 copied down =IFERROR(SUBSTITUTE(B2,$E$2:$E$6,""),B2)

Or to remove the double hyphen left by the above >> =IFERROR(SUBSTITUTE(B2,$E$2:$E$6&"-",""),B2)

[Navi_G]

Remove column just as example and it not for helper

Remove mean all text remove and 221-2018 shown as a result without remove column...

[JohnTopley]

Try

=IF(ISNUMBER(LEFT(B2,3)+0),LEFT(B2,4)&RIGHT(B2,4),RIGHT(B2,4))

[sandy666]

something like that?
Done with PowerQuery

	B	C
1	Cust. Codes	result
2	221-AVA-2018	221-2018
3	222-AVB-2018	222-2018
4	223-AVC-2018	223-2018
5	224-AWA-2017	224-2017
6	225-AWB-2017	225-2017
7	226-AWC-2017	226-2017
8	AXA-2015	2015
9	AXB-2015	2015
10	AXC-2015	2015
11	AYA-2015	2015
12	227-AYB-2016	227-2016
13	228-AYC-2016	228-2016
14	229-AZA-2016	229-2016

[Navi_G]

Dear Sir,

what steps involve please inform me for as a student of power query...

[Navi_G]

Try

=IF(ISNUMBER(LEFT(B2,3)+0),LEFT(B2,4)&RIGHT(B2,4),RIGHT(B2,4))

Dear Sir,

Formula is not working on:

AXA-2015 FALSE
AXB-2015 FALSE
AXC-2015 FALSE
AYA-2015 FALSE

Please Help on this issue...

[sandy666]

what steps involve

1st. don't quote whole post
2nd. open PowerQuery Editor, on the right side you'll see the steps or from the menu open Advanced Editor with steps detailed.

For student:
Microsoft Power Query for Excel Help

[Navi_G]

Thanks i try and inform you to what happend

[JohnTopley]

See attached

[jtakw]

Hi,

JohnTopley's formula works for all your given samples and should Not produce a FALSE...

Here's another formula option for your given samples: =REPLACE(B2,SEARCH("A",B2),4,"")
Formula copied down.