Power Platform Community Forum Thread Details

I am trying to delete all the dots within multiple cells in a table in Excel

However, neither the "Replace text" nor "Find and replace cells" actions works due to not accepting blank spaces as input:

Also tried putting it as an empty string ("") but it just overwrite the quotation marks

The data has 2 dots in between numbers, and is the only column in the table that must be free from dots (Tariff Code column):

Any ideas how this could work?

Categories:

Power Automate Desktop

Hi,

You can do this deletion on the fly without grabbing all the data into datatable.

Just use "Find and replace cells in Excel worksheet" as like below and replace all your dots with empty string and save your excel document.

Full code(Copy and paste the below code into your power automate desktop designer screen):

Excel.LaunchExcel.LaunchAndOpenUnderExistingProcess Path: $'''C:\\Boot\\ticket_intake_table.xlsx''' Visible: True ReadOnly: False Instance=> ExcelInstance
Excel.FindAndReplace.FindAndReplaceAll Instance: ExcelInstance TextToFind: $'''.''' TextToReplaceWith: $'''%''%''' MatchCase: False MatchEntireCellContents: False SearchBy: Excel.SearchOrder.Rows Cells=> Cells
Excel.SaveExcel.Save Instance: ExcelInstance

In case if you want to different approach, let me know.

Thanks,
Deenuji Loganathan 👩‍💻
Power Automate Desktop Community Champion 🤖
------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and like my suggestion ❤️ Your feedback supports future seekers 🚀