Sergio has attended:
Excel VBA Intro Intermediate course
How to indicate any text/letter value in Excel
Hi All,
I need to know if there is a way in excel to express the concept any letter value...basically I need to separate some text in which I have a variable number of numeric values first and then letters.
i.e.
123French
2323123Italian
The idea is to use the "find" formula first to find where the first letter happens to be.....however I don't know how to express that and please don't aske me to nest an enourmus series of or formula with all the alphabet
Thanks
Sergio
P.S.
The two parts have no space or any special value that I could use.
P.S.
Text to column won't work
RE: How to indicate any text/letter value in Excel
Hi Sergio
We have had a look at your post and at this stage have not found a recommended solution.
What we may be able to do is review your files if you can send them through and see if we can find a solution. Please note this may incur trainer development time and this will mean related costs. We will advise on these before we progress any work.
If you have any questions please email me direct.
Regards
Jacob
