Substitute text into x in excel [Closed]

Registration date
Tuesday October 21, 2014
Last seen
October 27, 2014
Hi there,

I'm nowhere to run related to the above subject, hoping you can help me to sort out this issue.

In column/row A1 text is equal to "closed". What I wanted to do is that in B1 I want to mark letter "x" from the word "closed". Is there any formula or any related for me just to type the word closed without marking in B1 manually?

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!