Share via

Can I take a compound number in 1 column and separate into 2 columns

Anonymous
2016-04-21T17:36:54+00:00

I want to import my blood pressure readings into Microsoft HealthVault.  The program that I exported from records the blood pressure as 120/80 (systolic/diastolic).  HealthVault records the numbers into two separate columns - systolic in "column 1" and diastolic in "column 2".  

Is there a function that I can run that will separate 120/80 and place 120 in "column 1" and 80 in "column 2".

TIA

Ronald Bernier

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Ashish Mathur 101.8K Reputation points Volunteer Moderator
    2016-04-21T23:28:53+00:00

    Hi,

    Select the single column dataset and go to Data > Text to columns > Delimited > Other > / > Next > Finish.  This will separate 120/80 into two columns 120 and 80.

    Was this answer helpful?

    5 people found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ashish Mathur 101.8K Reputation points Volunteer Moderator
    2016-04-23T23:20:07+00:00

    You are welcome.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2016-04-23T01:05:43+00:00

    Thank you Ashish Mathur, your answer solved my problem.  Your help is appreciated very much.

    Was this answer helpful?

    0 comments