Home > Forum Home > Automating Data Analysis Tasks > Separating text from numbers Share

Separating text from numbers

Excel Help for Separating Text From Numbers in Automating Data Analysis Tasks


Forum TopicPost Reply Login

Separating Text From Numbers

Rate this:
(3/5 from 1 vote)
ConfusedI have a list of around 100 including text & numbers clubbed together

for ex

clear 1234
mirror 456
reflective 3450

is there any way I can saperate text from the numbers using a single formule

not using VBA

the no. of digits in the numbers is not constant but varies from 2 to 6

and similarly text lenght is also not fixed

Is there any way excel can recognize numbers from alphanumerics


 PD
 Posted by on
 
Replies - Displaying 1 to 1 of 1Order Replies By: Most recent | Chronological | Highest Rated
Confused
Rate this:
(3/5 from 1 vote)
If each cell is always text then space then number, you can get the text using a LEFT function and FIND function on the space.

Assume your text is in cell B3, the formula would be =LEFT(B3,FIND(" ",B3))
 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Separating text from numbers in the