LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jen Jen is offline
external usenet poster
 
Posts: 119
Default How to 'split' data from 1 column into 2??

Hi!

Can anyone help me with a formula for Excel 2003 to split data from 1 column
into 2?

Data Examples:
COUN1234
PS3524
PSY5002

I want to have a formula to split the alpha data from the numeric data. As
you can see, the alpha data is of varying lengths.

Thanks ahead of time for anyone who can assist with this!

-Jen;-)

Jennifer Moulton

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Shortcut to split data from one column into three? HELP! LenoraMarie Excel Worksheet Functions 3 June 25th 08 04:17 PM
Split Data in One Column Into Two RoadKill Excel Discussion (Misc queries) 2 March 10th 08 10:14 PM
Split data in column Kat Excel Worksheet Functions 1 November 3rd 05 02:19 AM
How do I split data in a column (formula)? dan Excel Discussion (Misc queries) 7 July 6th 05 12:12 AM
How to split one column into two? Robert Judge Excel Worksheet Functions 6 December 24th 04 06:36 PM


All times are GMT +1. The time now is 12:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"