Data Cleaning-Replace text from upper cell

[Faruk Hosen]

Hello,
I need a formula which will replace text of cells from upper cell

file is attached.

Thanks.

 

[NARAYANK991]

Hi ,

See if this works.

Narayan

 

[Faruk Hosen]

Worked. but what if started with number.

Thanks.

 

[NARAYANK991]

Hi ,

The IF formula will then change accordingly ; can you specify what are all the possible characters ?

Narayan

 

[Naresh Yadav]

Dear Faruk,

one more option which based on your data structure

=IF(LEN(A2)>4,A2,B1)