I need a macro to delete a leading apostrophy from '=a1.

Microsoft Microsoft excel 2007 full vers...
March 3, 2012 at 21:51:18
Specs: Windows XP
How to convert text to formula? I need a macro to delete a leading apostrophy from '=a1 and return the formula =a1.

See More: I need a macro to delete a leading apostrophy from =a1.

Report •

#1
March 4, 2012 at 11:16:47
The quickest and easiest way short of using a macro is do a Text to Columns:

Select the column/cells you wish to convert
Select Data from the ribbon
Select Text to Columns

Just walk thru the "wizard" and select "general" as the column format.

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question