Hi All,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
></o>
<o></o>
Just wanted to inquire, I’m currently converting a whole column of alpha numeric data into just numeric, eg. AB1234 to 1234, I used the Right(A1, 4) function to remove all the letters in that particular column and plan to copy/paste these to overwrite that column since I don’t need the alpha’s. My question is, thou I’m using the function to remove the letters, there are some rows that has different formats that I need to leave just as it is, so when I’ll do the copy paste values on the column that I need to replace, I wanted some of these rows that I don’t need to change to be untouched (with blank cells on rows that will replace), to reiterate my question, here’s the scenario:<o></o>
A B<o></o>
AB1234 1234<o></o>
BC5678 5678 <o></o>
910111 (blank) <o></o>
DE1213 1213<o></o>
I do not like to overlap the 3<SUP>rd</SUP> row (910111) but as copy paste the whole column B to A, this will inadvertently be included, I tried the filtering of rows but I find it really manual as it is only not the unique rows that I wanted to leave as is, is there a function that will leave this untouched?<o></o>
<o>thanks! </o>
fficeffice" /><o></o><o
></o>Just wanted to inquire, I’m currently converting a whole column of alpha numeric data into just numeric, eg. AB1234 to 1234, I used the Right(A1, 4) function to remove all the letters in that particular column and plan to copy/paste these to overwrite that column since I don’t need the alpha’s. My question is, thou I’m using the function to remove the letters, there are some rows that has different formats that I need to leave just as it is, so when I’ll do the copy paste values on the column that I need to replace, I wanted some of these rows that I don’t need to change to be untouched (with blank cells on rows that will replace), to reiterate my question, here’s the scenario:<o
></o>A B<o
></o>AB1234 1234<o
></o>BC5678 5678 <o
></o>910111 (blank) <o
></o>DE1213 1213<o
></o>I do not like to overlap the 3<SUP>rd</SUP> row (910111) but as copy paste the whole column B to A, this will inadvertently be included, I tried the filtering of rows but I find it really manual as it is only not the unique rows that I wanted to leave as is, is there a function that will leave this untouched?<o
></o><o
>thanks! </o>
