hi guys,
i had a problem.i wanna to concanate two cells and extract out the decimal numbers in front it.please help.
hi guys,
i had a problem.i wanna to concanate two cells and extract out the decimal numbers in front it.please help.
Are your numbers in front always the same length as your example? Something like this would work if so... =MID(B2,7,99)&" and "&MID(B3,7,99)
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
yes,there are
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks