How to extract Fist number and last number like this, please see attached file, thanks!
How to extract Fist number and last number like this, please see attached file, thanks!
Who can help me????
Hi,
a first attempt: it should work when the strings contain capital letters (A C X ) and numbers.
In F2 to be confirmed with control+shift+enter:
In G2 to be confirmed with control+shift+enter:Please Login or Register to view this content.
Please Login or Register to view this content.
Hope you'd get better solutions
Regards
Edit:small example attached ; I've used only integers, Italian settings could not recognize as numbers 1.07 1000.75
Last edited by canapone; 05-07-2012 at 03:18 AM.
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
Thank you so much for your help!
But that is sample data, original data has more 1000 rows. who can hepl me write CODE VBA?
UDF
F2:
=SumNumbers($B2:$E2,TRUE)
G2:
=SumNumbers($B2:$E2,FALSE)
then filldown
Please Login or Register to view this content.
@Jindon : I want to say with you "Thank you very much". It's wonderful!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks