Strip Data

[hftechno]

I have attached a sheet for reference. Looking for code to strip data from columns "M:AH"

MONTH 02-08/02-28 WOULD BECOME "2" FOR THE MONTH OF FEBRUARY

MONTH 06-01/06-30 WOULD BECOME "6" FOR THE MONTH OF MAY


Thanks!

[Roel Jongman]

if this is a one of action instead of looking for a formula. Try following search and replace

Search: "Month "
Leave replace field blank

then
Search: "-*"
Leave replace field blank

the second search has * for a wildcard so - and everything after it will be deleted leaving only the month numbers..
Excel auto assumes 02 is presented as the number 2 and so on..

[alansidman]

Please Login or Register  to view this content.

[hftechno]

alansidman... perfect !!!