Hi,
Could anyone write for me a function for Excel in VBA, that extracts from String "=TRIM(CLEAN('SomeSheet'!A8))" a substring "'SomeSheet'!A8" ?
Thank you for help, I 'm not familiar with VBA.
Hi,
Could anyone write for me a function for Excel in VBA, that extracts from String "=TRIM(CLEAN('SomeSheet'!A8))" a substring "'SomeSheet'!A8" ?
Thank you for help, I 'm not familiar with VBA.
=SUBSTITUTE(SUBSTITUTE(F1,"=TRIM(CLEAN(",""),"))","")
with the data being in cell f1
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
Try something like
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks