Posted to microsoft.public.excel.programming

cstang[_2_] cstang[_2_] is offline

external usenet poster

Posts: 2

Split Alpha/number

Hi,
Can anyone pls help me with...Thanks in advance.

ColumnC
P5704
P5822(AB)
CA072407
P6384A
SGA 525
K2201/367
K402AA

Result in ColumnB as:
P
P
CA
P
SGA
K
K
Thanks in advance.

CSTANG

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
Split Alpha Field	Dick W.	Excel Worksheet Functions	2	August 18th 08 05:05 PM
number alpha list w/duplications	Deb	Excel Discussion (Misc queries)	4	February 11th 08 12:03 AM
alpha field getting turned into an exponential number	dkellison	Excel Programming	3	July 27th 06 07:43 AM
Split the numbers in a alpha numeric case	Jp	Excel Discussion (Misc queries)	5	April 7th 06 09:29 PM
in excel how do I show a number as an alpha eg 65 as sixty five?	Changing numbers to Alpha in Excel	Excel Worksheet Functions	5	April 1st 05 12:33 PM

All times are GMT +1. The time now is 08:07 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us