Here have some information in cell A1.

Then cell B1 has a formula (called "Formula1") to modify A1, resulting in B1 value.

Then cell C1 has a formula (called "Formula2") to modify B1 whose value was created after applying its formula to A1, resulting in C1 value.

Is there a way that I can write a formula which asks him in a single cell to do first formula 1 then formula 2 without needing to write 2 different formulas in different cells?

I tried writing in the formula box like this but it is comparing one to another instead of doing one then the other with the result of the first one:

=Formula1

=Formula2

Also tried =Formula1&Formula2 and =Formula1+Formula2, but they do other things...

How could I write formulas in a single cell saying:

=Formula1 THEN Formula2 THEN Formula3, etc. (each higher formula being done to the result of the former one)

Thanks

## Example

Input Cells

A1:Michael.John$Josh.Andrews

A2:Michael%Josh.Andrews

A3:Michael John

A4:Michael.John

Formula1 for column B: =LEFT(A1,FIND("$",A1& "$")-1)

Formula2 for column C: =IF(SUMPRODUCT(LEN(B1)-LEN(SUBSTITUTE(B1,"$","")))=1,LEFT(B1,FIND("$",B1)-1),IF(SUMPRODUCT(LEN(B1)-LEN(SUBSTITUTE(B1,"%","")))=1,MID(B1,FIND("%",B1)+1,LEN(B1)-FIND("%",B1)),IF(SUMPRODUCT(LEN(B1)-LEN(SUBSTITUTE(B1,".","")))>=1,B1,"")))

I am having to write column A, Then do formula1 for getting column B, Then again do formula2 on top of column B value after its formula 1 result, for just then to get column C. This is making the excel chart display information that I dont want it to appear nor calculate by parts, but show only final result calculated at once.

I would like to have only columns A and B in which A is the input, and B has all the formulas calculated at once. How do I do one single formula with those 2 formulas to be done first formula1 and then formula2 applied to formula1 result directly?

Thanks