question

Harish-3100 avatar image
0 Votes"
Harish-3100 asked RichMatheisen-8856 commented

I've an excel with few columns containing data with - as separator and that needs to be changed into _. For instance, column A has data like this app-123 in cell 1 and cell 2, anc-123-xyz amd cell 3 abg-56d. These - should be replaced with _

I've an excel with few columns containing data with - as separator and that needs to be changed into . For instance, column A has data like this app-123 in cell 1 and cell 2, anc-123-xyz amd cell 3 abg-56d. These - should be replaced with using powershell.
I've 3 columns with such data. There are blanks in few cells as well.

On these values, 2nd requirement is I should do text to columns functionality using powershell.

Can any one help me with such information to proceed

windows-server-powershell
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Does the spreadsheet contain only data? Or does it also contain formulas? Is there formatting (other than the default) applied to cells?

Assuming only data, no formulas, and no formatting, you can export the data from Excel into a CSV file. Import the CSV into PowerShell, make your modifications, and export the result to another CSV. Then use Excel to import the modified data.

0 Votes 0 ·

0 Answers