Previous Topic Next Topic

Need to seperate data from one cell into multiple.

Closed
Hacky - Nov 11, 2016 at 05:32 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 14, 2016 at 11:18 AM
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 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Nov 14, 2016 at 11:18 AM
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

Similar discussions

Unlock safe folder without losing any data
Mintu -
HelpiOS -

1 response
How To Fix Mint Mobile Data Not Working?
sachin327 -
joshitha -

2 responses
AMD data change update new data to DMI
Luis -
dwebb -

1 response
Cannot download multiple files at once in WhatsApp Web
nemonavicusrino -
dannygzus -

4 responses