Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Alex Evans   on Jan 26 In MS Office Category.

  
Question Answered By: Bama Cohen   on Jan 26

You don't need VBA to accomplish your task.

Save the workbook, then do the following:
1) With the replace function, replace "=" with "'="

Now you have only text.

2) Replace ")*2" with ""

3) Replace "(" with ""

4) Replace "'=" with "="
*******************************************
Or simplified, just replace "*2" with "". That will also do the trick

Share: 

 

This Question has 1 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Macro to remove brackets Or get search suggestion and latest updates.


Tagged: