VB Code to split data from Column A and put in Column B,C and D

[rizmomin]

Hello:

Please refer to attached file.
I will have data as shown in column A.
I need VB code to split the data from column A into Column B,C,D and E as shown.
Negative data will be column D as it is Disc/Sur.

I have manually added data as shown in Orange highlighted field.

Let me know if you have any questions.
Thanks.
Riz

[nilem]

Hi Riz,
maybe something like this

Please Login or Register  to view this content.

[rizmomin]

Hi Nilem:

Please refer to attached file.
Sheet2 is the result of the code.
I need the result as shown in column B,C,D,E as shown in Sheet1.

Let me know if you have any questions.
Thanks.

[rizmomin]

Hi Nilem:

Looking at the data and your code, just a suggestion that first step would be find text and delete the space in the first word in column A.
Example :

Monthly Report make it to MonthlyReport
Org Jul make it to OrgJul
CHRG TIP make it to CHRGTIP
GROS REVENUE make it GROSREVENUE
C Card make it CCard
and so on..
Please let me know if you have any questions.
Thanks.

Riz

[nilem]

maybe so

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[rizmomin]

Hi Nilem:

That would work.
B column should not have "-".
If there is "-" in B column then need to be in column C.
Please let me know if you have any questions.
Thanks.

Riz

[nilem]

Here try it, is it works for you?

[rizmomin]

Hi Nilem:

Seems to work.
Will try further and let you know if any problems.
Thanks a lot
Riz