Any assistance would be appreciated on my question below.
I have a spreadsheet with two columns that already have data and a third column that I am using the TRIM function on to take part of the value in column B. Here is the function that I am using in column C ‘=VALUE(TRIM(CLEAN(RIGHT(B2,6))))’.
As can be seen, it works great when the value in column B does not have any alpha characters.
A B C
7400 AAAA\002810 2810
5481 AAAA\000210 210
4632 AAAA\ahmede #VALUE!
4091 AAAA\002950 2950
3711 AAAA\000803 803
I need to do three things:
1) Get the formula to work for all lines
2) Get the result from column C to replace the info in column B as a value
3) Create a VB macro so I can run it each month.
Thanks in advance for your assistance
Wingale
Bookmarks