omrangassan
New Member
- Joined
- Jul 24, 2016
- Messages
- 2
extract +/- numbers from alphabet cell %&AmK !
hi sir
I'm doing some research, and I have excel sheet attached with 3 columns; cells are complex alphabet (%+-aKM&) with numbers (+-).
FOR MY STUDY PURPOSES - i want to extract only the numbers value (be care that some numbers are +; others are - ; if you look into the cells you will get my point about the - sign ! : it appears in complex places between alphabets).
Please look carefully for the - sign in any cell ; it appears in complex ways !
Is there anyway to extract only numbers with its sign (+ or -) from the three columns (columns A,B,C) and make new columns (D,E,F) with numbers values (+ -) only extracted from columns A,B,C ?
This will truly help me in my research thesis.
I'll appreciate your favor.
excel sheet link - http://www.filedropper.com/excel_4
Best Regards
hi sir
I'm doing some research, and I have excel sheet attached with 3 columns; cells are complex alphabet (%+-aKM&) with numbers (+-).
FOR MY STUDY PURPOSES - i want to extract only the numbers value (be care that some numbers are +; others are - ; if you look into the cells you will get my point about the - sign ! : it appears in complex places between alphabets).
Please look carefully for the - sign in any cell ; it appears in complex ways !
Is there anyway to extract only numbers with its sign (+ or -) from the three columns (columns A,B,C) and make new columns (D,E,F) with numbers values (+ -) only extracted from columns A,B,C ?
This will truly help me in my research thesis.
I'll appreciate your favor.
excel sheet link - http://www.filedropper.com/excel_4
Best Regards
