0

I have been trying to do this for quite some time.

I have an excel sheet has text In-today and "Starting" as well as other text that is meant to be there. How do I create a formula that replaces the words In-Today and first word "Starting" in Column A with word "N/A"

SUBSTITUTE(A2,"In-Today","N/A") works but what about "Starting".

Col A
In-Today
Starting by the side of the ridge
Starting at 14:00
In-Today
Starting 15:00
Starting adwada14

Thanks

  • Substituteception https://stackoverflow.com/questions/22313965/how-can-i-combine-multiple-nested-substitute-functions-in-excel – nckro Jun 28 '17 at 15:43

1 Answers1

0

Try this:

=SUBSTITUTE(SUBSTITUTE(A2,"In-Today","N/A"),"Starting","N/A")
Pang
  • 9,564
  • 146
  • 81
  • 122
Shums
  • 32
  • 3