dommie
New Member
Hi everyone,
I'm currently updating some transaction databases but have been manually eyeballing the numbers in my columns and typing in what it's supposed to match to. To illustrate:
Row 1: 1000728
Row 2: 7839222
Row 3: 1000364
Row 4: 2736409
What I'm trying to do is - any number that begins with '1000' means that it's a transaction that occurred from Machine A; any other number is associated with other machines.
As I'm an Excel newbie, I understand that I can do IF functions but I do not know how to specify to look at the first 4 numbers (for example) to match it to the word "Machine A". Basically - if Row X has "1000XXXX", = "Machine A".
Thank you and appreciate the help.
I'm currently updating some transaction databases but have been manually eyeballing the numbers in my columns and typing in what it's supposed to match to. To illustrate:
Row 1: 1000728
Row 2: 7839222
Row 3: 1000364
Row 4: 2736409
What I'm trying to do is - any number that begins with '1000' means that it's a transaction that occurred from Machine A; any other number is associated with other machines.
As I'm an Excel newbie, I understand that I can do IF functions but I do not know how to specify to look at the first 4 numbers (for example) to match it to the word "Machine A". Basically - if Row X has "1000XXXX", = "Machine A".
Thank you and appreciate the help.
