need excel expert

[aivijardin_09]

Hi,

I'm not good in excel, I would like to ask your assistance on how can i get the right formula.

Here's the problem.
I need to move BIR Tax Code to the next column. What would be the best formula for these.


` Result
Name Proper Government ID Type Government ID BIR Tax Code
Maria Geneline Blanco Tax ID (TIN) 108669865 ME
Maria Geneline Blanco BIR Tax Code ME
Maria Geneline Blanco
Ma Lourdes Lavina Tax ID (TIN) 132188538 S2
Ma Lourdes Lavina BIR Tax Code S2
Ma Lourdes Lavina

 

[Yahya]

Try this

Excel Workbook
	A	B
1	Name Proper Government ID Type Government ID BIR Tax Code
2	Maria Geneline Blanco Tax ID (TIN) 108669865 ME	108669865
3	Maria Geneline Blanco BIR Tax Code ME
4	Maria Geneline Blanco
5	Ma Lourdes Lavina Tax ID (TIN) 132188538 S2	132188538
6	Ma Lourdes Lavina BIR Tax Code S2	2
7	Ma Lourdes Lavina
Sheet3

Excel 2007

Cell Formulas
Range	Formula
B1	=MID(A1,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")),SUMPRODUCT(--(ISNUMBER(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)+0))))

 

[aivijardin_09]

Yahya,

Thank you for the formula but the result are not correct

The result should be like these



Name Proper Government ID Type Government ID BIR Tax Code
Maria Geneline Blanco Tax ID (TIN) 108669865 ME
Ma Lourdes Lavina Tax ID (TIN) 132188538 S2

 

[Jonmo1]

Please show a few rows of before AND after examples...

My source data looks like
ABC
DEF
GHI

From that data, I want to return
RST
UVW
XYZ


Please use the Excel Jeanie to post sample data, see my signature for a link to it.

 

[aivijardin_09]

Hi,

My Data

Name Proper_________Government ID Type____Government ID
Maria Geneline Blanco__Tax ID (TIN)__________108669865
Maria Geneline Blanco__BIR Tax Code__________ME
Maria Geneline Blanco
Ma Lourdes Lavina____Tax ID (TIN)___________132188538
Ma Lourdes Lavina____BIR Tax Code__________S2
Ma Lourdes Lavina

Column A - Name Proper
Column B - Government ID Type
Column C - Government ID
Column D - BIR Tax Code

Result should be
Name Proper Government ID Type Government ID BIR Tax Code
Maria Geneline Blanco Tax ID (TIN) 108669865 ME
Ma Lourdes Lavina Tax ID (TIN) 132188538 S2