I have some high/low temperatures data in the following form:
101°/78°
81°/63°
25°/9°
I would like the high and low to be numbers in separate cells. I came up with these formulas, but they work only if both temperatures are 2 digits:
=VALUE(LEFT(A1,2))
=VALUE(MID(A1,5,2))
I need a formula that works for all of the above examples. Using Excel 97. Thanks.
Ken
Enter formula in cell B1 and pull to C1 and down
Formula:
Please Login or Register to view this content.
v A B C 1 101°/78° 101° 78° 2 81°/63° 81° 63° 3 25°/9° 25° 9°
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
In B1 type =LEFT(A1,FIND("/",A1)-1) and copy down
In C1 type =RIGHT(A1,LEN(A1)-FIND("/",A1)) and copy down
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Do you have to use Excel? This would be really easy in Google Sheets using Google's SPLIT() function: https://support.google.com/docs/answer/3094136?hl=en
Originally Posted by shg
Thanks for the replies. I wanted the results to not include the degree sign,
but was able to modify alansidman's formulas to accomplish that. Appreciate the help!
Ken
Here is a modified version without degree sign
Formula:Please Login or Register to view this content.
Or these
in B1
Formula:Please Login or Register to view this content.
in C1
Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks