SOLVED

Removing data from cell

Contributor

Hello,

In Cell D2, I need only the name i.e. Tanvir Ahmed from Cell B2 without : and space. How may I get it?

 

Thanks in advance.

Oliullah_Siddique_1-1659597720403.png

 

 

2 Replies
best response confirmed by Oliullah_Siddique (Contributor)
Solution

@Oliullah_Siddique This could work:

=SUBSTITUTE(B2,": ","")
@Riny_van_Eekelen Thanks a lot!