Need function to return numbers at beginning of text

N

Nadine

I have a column of cells that contain an id and description in one column. I
need a formula that will give me only the id. The id can be either 4 or 5
numbers. Some can be followed by a letter and some can be followed by a dash
and then a number. What they all have in common is that the id is followed
by a space and then the description.

So, the =LEFT formula will not work. I need on that can give me all
characters before the space regardless of whether that's after the first 5
characters or after 7 or 8 or however many there are before the space.
Anyone know of such a formula for Excel 2003? Thanks so much.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to remove a combination of letters and special characters 2
Space at end of multi page list to accommodate new entries 1
Need help removing extra TOC text from number lists used as TOC levels 0
Save as word to xml is splitting place holders ex: $abc.xyz$ 0
Using FIND to highlight text (with dashes) 4
Consolidation Table from Different Excel Tabs with Different Format 1
How to Import Formatted text as new Slides in PowerPoint 0
Visio 2010 - Organization Chart Wizard - Hebrew Excel Database 0

Top