How to align center text cellvalue in excel

[Raja.G (Mr.RPABot)]

Hi Team,

I need to particular cell value to align center but cell value below format so i couldnt able to set center please help me anyone for this.

Cell value shows like
Output
03.12.23
Output keyword is center but i couldnt able to move date to center
Date is left align

I want both center align

Expected format:

Regards,
Raja G

[Anil_G (Anil Gorthi)]

@Raja.G

Did you happen to try using format Cell activity

cheers

[Raja.G (Mr.RPABot)]

Hi @Anil_G ,

Yes tried actually im finding “Output” keyword only so i can able to set center but date i couldn’t able to do because date is new line of that cell so i coludnt able find

I tried “output” Environment newline that syntax also but not worked

[Anil_G (Anil Gorthi)]

@Raja.G

Giving the cell
Number and selecting centre in Horizontal is not moving everything to centre?

I Just tried it on same file you gave and it did move both

I beleive environment.Newline is already part of it so no need of it to be separately included

Cheers

[Manish540 (Manish Shettigar)]

Hi @Raja.G ,

Check this below attached workflow,
Uipath_AlignTextCenter.xaml (6.4 KB)

Files Used:
GetAddressAndAlignCenter.txt (264 Bytes)
Book1 (1).xlsx (11.3 KB)

Parameters: {"Your Sheet Name","Text to Find"}

Hope this may help you

[Raja.G (Mr.RPABot)]

Hi @Anil_G ,

Yes worked fine
Horizontal
Center
Vertical
Top
Below again i added format cell
both i put center working fine thanks

[Anil_G (Anil Gorthi)]

@Raja.G

If solved please mark the solution else happy to help

Cheers