Insert numberrs in from of speciified Text

[howard]

I have the following text the appears in Col A

1) Where East appeas in Col A and EA01 does not appear at the beginning on the text , I need EA01- to appear in front on the text

2) Where BR1 appears in Col A and EA02 does not appear at the beginning on the text , I need EA02- to appear in front on the text

Your assistance in this regard is most appreciated

 

[Herbiec09]

will East be the only value in the cell or part of some text?

 

[howard]

Thanks for the reply. It is part of the text in col A

 

[howard]

See Sample Data below to give you an idea of hat the data in Col A looks like

Excel 2012
	A
1	PO 1258 BR1 05 - ORDER 2893
2	PO 1272 EAST 04 - DOC 364
Sheet1

This is what data must look like after running Macro

Excel 2012
	A
1	EA01-PO 1258 BR1 05 - ORDER 2893
2	EA02-PO 1272 EAST 04 - DOC 364
Sheet1

Your assistance in this regard is most appreciated

 

[ztodd]

You can do it without a macro- insert a column and use functions to generate what you need -
Look up and play around with the "search" function or the "find" function, and the "if" function. You probably also need to understand the "and" function and the concatenation operator, &.

Try to learn how to to use these things for yourself... don't rely on others to always give you the final code or formula you need.