Combine Calculate in a cells with several calculate in that cell and after that another calculate based on that cell

[Unexpc]

Hi guys
i have main problem and if you solve this, solve my main problem and helped me to calculate any of numbers that i do this in many hours
this is my problem
i have this worksheet that you see before, in first i said that belong to text, but that have information for main calculate, better say
in one cell i write information with this format : Give (+ Value) or Receive (-Value) ,G Or M, Text, Number, Percent or Thousands or Hundred (if Give and G and Percent: Percent that multiply to Number that written before this (if i not write anything in this part, multiply with 1), if Give and G and Thousands: Thousand multiply with number, if Receive and G and Percent: Percent multiply with number, if Receive and G and Hundred: Hundred multiply with number and then divide 750, for Give M that all this value sum and fill in specific columns that i say in below but for Receive M, if write MM after that calculate: Number multiply MM and divide 4.3318 if not write like Give M Calculate)
This fill in Column A
Columns B:C fill with Text without calculate
but in Column D
This fills with SUM of Gives and Back (+ Value) Calculates from G
in Column E
fills with SUM of Receive (- Value) Calculates from G
in Column F
fills with SUM of Gives (+ Value) Calculates from M
in Column G
fills with SUM of Receive (-Value) Calculates from M
and a point, i can't split information that belong one cell, because all of the info about a day and should write all info in one cell

 

[maabadi]

Please upload your example with Xl2bb Addin or excel file at free hosting sites e.g. GoogleDrive and insert link here.
And please write all possiblities for your Data.
About me, For now I'm not in my Country now until end of July & don't access to PC. Maybe others have better option.

 

[maabadi]

I need to see your exact text format within cell to know how work on it. please upload example file with all possibilities

 

[Unexpc]

I need to see your exact text format within cell to know how work on it. please upload example file with all possibilities

yes, please wait i try write a example file that i can say what am i want

 

[Unexpc]

I need to see your exact text format within cell to know how work on it. please upload example file with all possibilities

please see this

Book1.xlsm

drive.google.com

 

[maabadi]

Two Problems
1. I don't understand which cell Content should be Splitted ( Is it A6?)
2. If it is A6, I cann't write macro to find Persian letters? I need English language for macro.

 

[Unexpc]

Two Problems
1. I don't understand which cell Content should be Splitted ( Is it A6?)
2. If it is A6, I cann't write macro to find Persian letters? I need English language for macro.

1.A6 is main cell
2. no problem, i define a symbol for persian letters, for example i write + instead of پرداخت and other letters (other example for کالا i write ]), just say this is ok? if it is ok, i say symbols instead of this words
and i think again for other method that no need to this symbols,,, anyway that find out between seprate (،) ? have a idea about that?

 

[maabadi]

OK. Then Use English Symbol or Letters at A6 and upload file again to I work on it.

 

[Unexpc]

OK. Then Use English Symbol or Letters at A6 and upload file again to I work on it.

Book1.xlsm

drive.google.com

please check it:
and anyway fixed aligned text? (i write in file what i mean)

 

[maabadi]

Questions:

1. Are you always have at Cell A6 Equal sign (=) at each line?
2. At Cell A6

calcuate eace item
item 1 = +1 * 23 + (23 * 10%) = A1
item 2 = +1 * 12 =B1 * 23000 = B2
item 3 = -1 * 56 + (56 * 8%) = C1
item 4 = -1 * 43 = (D1) * 11000 = D2
item 5 = +1 * 1200000 = E1
item 6 = +1 * 2300000 / 3300000 * 4.3318 = F1
item 7 = -1 * 1200000 = G1
item 8 = -1 * 2300000 / 3300000 * 4.3318 = H1

A. What is B1? I see text at Cell B1 & I don't Know How Calculate B1.
B. Same For D1?
C. At Item 6 & 8 : please define exact value you want with Parentheses?
For example is Item 6 is ;

 item 6 = (+1 * 2300000) / (3300000 * 4.3318) = F1

OR

 item 6 = (+1 * 2300000 / 3300000) * 4.3318 = F1