Hi Reehan,

Please also explain the problem in the thread so that others know what the problem is before downloading the file and the question and solution are searchable for others to find and seek help from.

Also, it's not clear in your file what you want, sorry. Even with the data and required your comments are confusing because you say 'without using any words like, sale or cash, yet your required example contains those exact words. Please clarify.

Mynda

Hi, 

I have an Excel sheet that has 2 Sections, names: Data Section & Example Section.

The example section is only for understanding, what I want.

I want lower cell Value to the back of the upper cell by using Formula.

Example:

These are three values in Column "C". 

                   Zafer

                   Cash

                   Sale

and Lower Value is "Sale". I want Sale in the Back of Cash Column "B"

I attach the file, kindly also check it as an example.

Thanks,

Reehan

You can't really do this with a formula as there's no consistent pattern, but you can use Power Query, see example file attached.

Note: can you please take care not to re-attach your file each time you edit your question. You've uploaded 7 extra files!

Thanks,

Mynda