Removing data from cell

[Oliullah_Siddique]

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.

[#2 · Accepted solution]

@Oliullah_Siddique This could work:

=SUBSTITUTE(B2,": ","")

[#3]

@Riny_van_Eekelen Thanks a lot!