ExcelBanter - Extract Alphabets and Numbers from a Cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Extract Alphabets and Numbers from a Cell (https://www.excelbanter.com/excel-worksheet-functions/447449-extract-alphabets-numbers-cell.html)

tahir4awan

Extract Alphabets and Numbers from a Cell

I want to make a formula so that it can extract alphabets and numbers from a string containing both alphabets and numbers.

Kevin@Radstock

You will need to post some samples of the data. If there are are spaces, hyphens etc have you tried Text to Columns.

Quote:

Originally Posted by tahir4awan (Post 1606588)

I want to make a formula so that it can extract alphabets and numbers from a string containing both alphabets and numbers.

tahir4awan

1 Attachment(s)

Quote:

Originally Posted by Kevin@Radstock (Post 1606591)

You will need to post some samples of the data. If there are are spaces, hyphens etc have you tried Text to Columns.

Here is the picture of the function

Spencer101

Quote:

Originally Posted by tahir4awan (Post 1606611)

Here is the picture of the function

The post above suggesting you show some sample data, was actually asking for more than just one row as that tells us very little.

Would the numeric part always be 3 characters and in the 4th, 5th and 6th character position?

Also would the text always be 9 characters long.

If so, then you can easily use =LEFT() & =RIGHT() to get the alpha and =MID() to get the numeric.

All times are GMT +1. The time now is 02:17 PM.