98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » How to indicate any text/letter value in Excel | Excel forum
How to indicate any text/letter value in Excel | Excel forum
Resolved · Medium Priority · Version 2003
Wed 23 Dec 2009, 17:08Delegate Sergio said...
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
Mon 28 Dec 2009, 13:15Trainer Jacob said...
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
Sun 3 Jan 2010: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Calculate age or serviceThe DATEDIF() function in Excel calculates the number of days, months, or years between two dates. So, this function makes it easy to calculate a person's age. To try this tip: |
