You can now run it as a macro to convert selected cells. If Not VarType(.Value2) = vbString Then GoTo NextCell Go to Insert > Module, Copy and Paste Kenneth's code: Sub Expo()ĭim cell As Range, s() As String, lng As Long, n As Integer Open your Excel File, Press Alt + f11 to open the VBA screen,
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |