Hi newbie here,
running excel:mac 2011 on MBP
I understand this is a bit of a long shot, but for a university project I have a massive list of data which has been compiled by two different researchers who have, somewhat annoyingly, coded their results in two different ways.
Is there a formula/tool in excel that allows you to do a mass edit of what is written in a cell?
I would settle for the actual words to search for; I think it's a string? or substring? and may have something to do with concatenation.
As an example, say half of the data is written in the format x-y-z, and the other half is x-z-y, is there a way to change one format to another without going through 16,000 cells retyping what's in them?!
Any help whatsoever would be massively appreciated
Examples of the actual two codes are shown below. Each different code format contains the same information just in a different order. I have colour coordinated the corresponding bits of data from each code which I would like to put into the same order. I hope that's not too cryptic and may make it easier to understand what the h*ll i'm talking about! I Would like the second format to become like the first.
7911_M_1-1-3_014_L
6083F101L1001
many thanks
running excel:mac 2011 on MBP
I understand this is a bit of a long shot, but for a university project I have a massive list of data which has been compiled by two different researchers who have, somewhat annoyingly, coded their results in two different ways.
Is there a formula/tool in excel that allows you to do a mass edit of what is written in a cell?
I would settle for the actual words to search for; I think it's a string? or substring? and may have something to do with concatenation.
As an example, say half of the data is written in the format x-y-z, and the other half is x-z-y, is there a way to change one format to another without going through 16,000 cells retyping what's in them?!
Any help whatsoever would be massively appreciated
Examples of the actual two codes are shown below. Each different code format contains the same information just in a different order. I have colour coordinated the corresponding bits of data from each code which I would like to put into the same order. I hope that's not too cryptic and may make it easier to understand what the h*ll i'm talking about! I Would like the second format to become like the first.
7911_M_1-1-3_014_L
6083F101L1001
many thanks