Removing Unwanted Characters & Moving Others

[bdb1974]

Hi all,

I'm needing some code that will remove an open quotation mark from the numerical value found in column A. This will be for every row with a numercal
value.

example problem: "360015
example answer: 360015

All numbers will be 6 digits

And I've got another issue with numerals in column C. To the left side of the Cell there maybe a Number or Letter. To The Right side of the cell
there will be a single or double digit number. Both will be separted by some space (6-8 spaces). As in the examples below:
(again what you see on each line is in one cell in col. C.

R 59
E 6
0 4

I need the value on the left side of the cell to be moved concenate/merge with the values in column B.


There's will be approx 2000 rows that will need to be checked for this occurrance. Since there's so many rows,
I'd really would like to use VBA and not formulas to accomplish this.

Again, as always your help in resolving this is much appreciated.

Thanks,

BDB

[Leith Ross]

Hello BDB,

This macro starts at cell "A2" on the ActiveSheet and continues down to the last entry in column "A". In column "A" only cells that have a double quote at the beginning and 6 numbers are changed to to 6 numbers. Any cell in column "C" that starts with a letter or number and is followed by one or more spaces will have the first character concatenated to the end of the string in column "B" of the same row.

Please Login or Register  to view this content.

[bdb1974]

Super!!!

One small problem,which is my fault for not stating, the characters in the left side of cells in column "C" are not being removed after being concatenated to the cells in B. I've tried adding the following statement to the last routine and since not working, must not be written right.

Please Login or Register  to view this content.

- BDB

[bdb1974]

This works, but it's got to work for various lengths to the right.
This is a Qty value which may vary from 1-10000.

Please Login or Register  to view this content.

[bdb1974]

I think it works with this.

Please Login or Register  to view this content.