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 552
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

Excel - IF function with multiple words
Nick -
user -

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

1 response
Unlock safe folder without losing any data
Mintu -
HelpiOS -

1 response
Counting cells containing only numbers
jutulu -
jutulu -

4 responses