Excel Text to Columns// Help me

[sahyunid1 (사현 김)]

I want to split text
Day and time coexist, but I want to leave only the date.
…UiPath is not up to date

don’t need anything except the date.

[lukas.gamper]

Hello @sahyunid1,

do you want to do that inside excel or with UiPath activities?

Just in Excel:

with “Text to Columns” you will overwrite E, F…

If you want to just display the date you can change it to just display the date by changing the format, the other information will still be in the cell though.

If you want to just get the date you can e.g. use an extra column and use the formula mid or left.

You could use a macro

Kind Regards

[Sudharsan_Ka]

HI @lukas.gamper

You can try with the text to column activity in the modern excel activities

Text to Columns

Hope this helps!

Regards
Sudharsan

[sahyunid1 (사현 김)]

Can I just leave the date? Is there any other way?

[sahyunid1 (사현 김)]

Is there any other way to solve it without invading other places?

[lukas.gamper]

Hello @sahyunid1,

with VBA macros or online with scripts.

an example VBA could be:

Sub removeTime()

    Dim idxRow As Integer
    Dim varSplit As Variant
    Dim ws As Worksheet
    
    Set ws = ActiveSheet
    
    For idxRow = 2 To ws.UsedRange.Rows.Count
    
        varSplit = Split(ws.Cells(idxRow, 1).Value, " ")
        ws.Cells(idxRow, 1).Value = varSplit(0)
        
    Next idxRow
    
    Set ws = Nothing

End Sub

Kind Regards

Edit: Grammar

[sahyunid1 (사현 김)]

Umm… I’m sorry I can’t use what you told me.
I’m new to VBA…

[pavan_kumar5 (pavan kumar)]

Hi @sahyunid1 ,

First of all read that excel file as data table. Keep it in for each loop and use the split condition for column ‘A’ as per the requirement. And append the output in another sheet or workbook. It will give the expected output.

Or You can use VBA or VBs scripts.

Regards,
Pavan Kumar

[lukas.gamper]

Hello @sahyunid1,

how do you want to solve it? VBA, Scripts in Excel online or via UiPath?

If we know how you want to solve it, we can help you a lot better. I can provide a guide to help with VBA, Scripts, UiPath like a lot of the other people here too but we need to know which way you want it to be solved.

Just with excel formulas wont be possible without creating another column.

Kind Regards