How do I remove the data in datetime format (in excel) and replace them with N.A.?
Appreciate for your help!
How do I remove the data in datetime format (in excel) and replace them with N.A.?
Appreciate for your help!
Hi Catherine, can you explain a little more about what you are trying to achieve? You can overwrite a cell easily enough within an Excel scope. Are you aiming to check a spreadsheet for cells that are formatted as date/time and then insert N.A as text?
Or are you working with a DataTable within UiPath and wanting to remove a column full of dates?
I’m sure we can help!
@JohnMac Hi John, I want to replace the cell that contains date(which is in date format in excel) with “N.A.” as text.
@JohnMac Hi John, but there are many rows in the excel, may I know how do I identify which row to insert “N.A.”? I just need the row that contains date to be replaced with “N.A.”
Thank you!
Hello @itsCatherine,
Do the following:
Cheers
@itsCatherine