Find and Replace, leaving leading zeros

[Jessica Conrad]

Hello!

I have a file that I use a macro in that does sub-totals of cutomer PO numbers. Below is examples of what's left in the column. I need to get rid of the word "Total" but keep the leading zero's of the PO. The PO's can vary in length with numbers and letters. When I'm doing a find and replace to take out the word Total, it also takes away the zero. Any thoughts?

0094832720 Total
020140808WCL Total

Thanks for any help!!

 

[Mike H..]

Hello!

I have a file that I use a macro in that does sub-totals of cutomer PO numbers. Below is examples of what's left in the column. I need to get rid of the word "Total" but keep the leading zero's of the PO. The PO's can vary in length with numbers and letters. When I'm doing a find and replace to take out the word Total, it also takes away the zero. Any thoughts?

0094832720 Total
020140808WCL Total

Thanks for any help!!

Hi,

I would use a helper column like this

=TRIM(SUBSTITUTE(A1,"Total",""))

 

[Jessica Conrad]

Hi,

I would use a helper column like this

=TRIM(SUBSTITUTE(A1,"Total",""))

Perfect!! Thank you so much This website is such a huge help!!