How to remove characters in Excel?

Hi everyone…
I have one excel sheet in that hours and minute contain like ‘8h 15m’, So from that i want to remove h and m how i do that .

.

Please help me .
Thank you.

Hi @Jitendriya it looks like the easiest way to do this will be by opening the file on the screen and using Excel’s built-in Replace feature

Hi @ashapkina, @Jitendriya,

Adding Note to that, you have to select only the range of values using “Get Range” and avoiding the header rows and then performing the replace options as shown below,

This will do the trick avoiding replacing the header texts.

Hope this helps :slight_smile:

1 Like

Thank you.

1 Like

Thank you so much…

1 Like