Splitting string into letters and numbers

Posted to microsoft.public.excel.programming

Foss[_2_]

external usenet poster

Posts: 7

Splitting string into letters and numbers

Hey there all,

I've got a few strings that need sorting. Some examples could be:

ABC123
ABFYE6
BHYF1478

I need to separate the letters and the numbers into two different columns.

How can this be done? Is there a way to identify whether a character is a
number, letter or symbol or something?

Thanks very much,
Pete

--
Cheers,
Foss

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro for detect palindromes and repeats in letters/numbers string	Luciano Paulino da Silva	Excel Worksheet Functions	33	April 16th 09 04:59 PM
Macro for detect palindromes and repeats in letters/numbers string	Luciano Paulino da Silva	New Users to Excel	5	April 14th 09 08:44 PM
Splitting complex string into 3 numbers with a formula - Please help!	Jason[_11_]	Excel Worksheet Functions	8	June 9th 08 06:46 PM
How can I convert a character string that contains letters & numbers "£2,456.99 (including flights)" into a numeric?	ship	Excel Worksheet Functions	4	April 3rd 07 02:35 PM
Splitting a text string into string and number	mcambrose	Excel Discussion (Misc queries)	4	February 21st 06 03:47 PM

All times are GMT +1. The time now is 05:20 PM.

Menu

About Us