LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default How to seperate ALPHANUMERIC data in a cell in an excel sheet.

Please Members, I would like somebody to help me on how to enter a formular
to seperate ALPHANUMERIC data in a cell in an excel sheet. For example, if a
cell contain 13050-300-000-000prepaid. What to do to seperate the numeric
from the alpha by entering formular in another cell.

Thank you.

Tiamiyu L.O
 
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
Copy data into new line on seperate sheet? sarah Excel Discussion (Misc queries) 1 May 12th 09 08:11 PM
flowing data to seperate sheet Jenner Excel Discussion (Misc queries) 3 February 9th 09 09:45 AM
How can I seperate text and number from alphanumeric cell? Jennifer Medina Excel Worksheet Functions 3 November 15th 07 11:27 PM
Does anyone know how I can seperate a post code in my data sheet? gsmcellular Excel Discussion (Misc queries) 3 July 8th 06 01:32 PM
Print data in each row on a seperate sheet template Chris Excel Discussion (Misc queries) 3 July 29th 05 01:51 PM


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

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

About Us

"It's about Microsoft Excel"