Separating text from numbers

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

Separating Text From Numbers

Rate this: (3/5 from 1 vote)

	I 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 pooja_dubey12 on 14 Jun 2008

Replies - Displaying 1 to 1 of 1

Order Replies By: Most recent | Chronological | Highest Rated

	Get the space character 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 Excel Helper on 16 Jun 2008

Displaying page 1 of 1