Hi, I am trying to create a macro to remove numbers and characters before a string of text on a very simple chart of accounts. Each row will have different amounts of characters, but all will have a hyphen, then a space, then the information I wish to keep.
Example:
1A - Fixed Assets
10 - Intangible Assets
Total 10 - Intangible Assets
11 - Tangible Assets
114 - Furniture, Fixtures & Fittings
114000 - Furniture
114500 - Accum Depreciation - Furniture
Total 114 - Furniture, Fixtures & Fittings
115 - Artwork
And I want to write a code so it looks like this:
Fixed Assets
Intangible Assets
Intangible Assets
Tangible Assets
Furniture, Fixtures & Fittings
Furniture
Accum Depreciation - Furniture
Furniture, Fixtures & Fittings
Artwork
Can anyone please give me the VBA coding to eliminate all the numbers and hyphens? I intend to insert a column firstly to copy the new format into.
Thanks!
Bookmarks