Need to seperate data from one cell into multiple. [Closed]

Report
-
Posts
2702
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
March 2, 2021
-
Hello,

I want to seperate and pull numbers from a paragraph in one cell.

Eg:
Temp: 35, rain: 2.56, humidity: 80%

I want to seperate into seperate cells.

Column C =35 Column D= 2.56 Column E= 80%

Please note the order can change and or other info can be added in which has thrown me out as I was using Split formula but that didn't work as the paragraph can change.

Thanks

1 reply

Posts
2702
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
March 2, 2021
457
Hi Hacky,

When the numbers don't change in length, you can use this:
=MID($A1,SEARCH("Temp:",$A1)+6,2)
=MID($A1,SEARCH("rain:",$A1)+6,4)
=MID($A1,SEARCH("humidity:",$A1)+10,3)

Best regards,
Trowa
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!