Posted to microsoft.public.excel.programming

Keith S[_2_] Keith S[_2_] is offline

external usenet poster

Posts: 2

Seperate letters and numbers in a cell

I have a spreadsheet where one column has cells with letters and numbers. I
want to seperate the letters into one cell and the numbers into another cell.
For example:

Cell Prefix Suffix
abcd041 abcd 041
qjwxkl678 qjwxkl 678
abc1455 abc 1455

Thanks for any help on this.

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
Seperate Alphabet and numbers in a cell	Kshitij	Excel Discussion (Misc queries)	7	September 10th 08 10:38 AM
Adding numbers in one cell and showing total in seperate cell	Deernad Construction	Excel Discussion (Misc queries)	12	November 29th 05 07:32 PM
SEPERATE NUMBERS IN A CELL	lehigh46	Excel Worksheet Functions	8	June 17th 05 12:22 AM
seperate numbers in a cell	rglasunow[_11_]	Excel Programming	1	January 26th 04 08:24 PM
Seperate numbers from letters	Jamal[_2_]	Excel Programming	2	December 17th 03 09:06 PM

All times are GMT +1. The time now is 05:37 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us