Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-18-2020, 02:02 AM
Ch0pe5 Ch0pe5 is offline Converting data using medical staging tools that come in a table form Mac OS X Converting data using medical staging tools that come in a table form Office 2016 for Mac
Novice
Converting data using medical staging tools that come in a table form
 
Join Date: May 2020
Posts: 1
Ch0pe5 is on a distinguished road
Default Converting data using medical staging tools that come in a table form

Morning all,



I'm having trouble figuring out how to convert my data between two different cancer staging methods. I've included a picture of the tool below so you get an idea.

http://patentimages.storage.googleap...00004_0001.png

Basically, I have the T, N and M data all listed in separate columns and I've used the CONCAT function to combine them because they all affect each other. I'm trying to convert the combined TNM stage to the staging with roman numerals for example:

T1 N0 M0 should become Stage I
T3 N0 M0 should become Stage IIA
T4 N2 M1 should become Stage IV
and so on.....

I've also attached an example set of data that I made I up that is similar to my original dataset: I've removed the wordy parts from the T, N and M categories and then combined them in the end column.

It's fairly complicated question but I can't help but think there must be a simple solution to it all.

Thank you!
Attached Files
File Type: xlsx Example.xlsx (9.7 KB, 3 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Converting into a fixed column width table with data alignment&table length under 72 colums samirahmed007 Excel Programming 0 01-18-2019 09:54 AM
Converting data using medical staging tools that come in a table form Change Drawing Tools to Text Box Tools to insert address in labels Alecf Drawing and Graphics 5 09-01-2017 05:27 AM
Converting data using medical staging tools that come in a table form Is there an unlock and lock button in form tools for Word 2013? rbush Word 7 12-09-2013 05:38 PM
Converting data using medical staging tools that come in a table form Converting data-table into coding text niuri_cigarete Excel 2 12-10-2011 02:57 AM
Tools for converting PowerPoint to screensaver. on_thefly Office 0 10-28-2010 01:21 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 03:34 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft