cubiclemonkey
New Member
- Joined
- Mar 7, 2012
- Messages
- 25
Good Afternoon,
I have a few data sets that I am downloading from SAP into excel and the data sets have labels in the subtotals in column B that aren't uniform. For example one data set will have 3 asterisks with spaces preceding the label like "*** Labour Costs" whereas another data set could have 4 or 5 asterisks. Is there a macro that can go through a set of tabs and delete out the asterisks for each data label irrespective of the number along with the spaces and just leave the label?
Thanks in advance.
Ahmed
I have a few data sets that I am downloading from SAP into excel and the data sets have labels in the subtotals in column B that aren't uniform. For example one data set will have 3 asterisks with spaces preceding the label like "*** Labour Costs" whereas another data set could have 4 or 5 asterisks. Is there a macro that can go through a set of tabs and delete out the asterisks for each data label irrespective of the number along with the spaces and just leave the label?
Thanks in advance.
Ahmed