Text Function help

[yessir]

I need to use the Text functions to put the product IDs and prices in separate columns. And by using the text function to display product ID code in Column D and price in column E


B C D E

Product ID and Price		Product ID	Price
xa1 304
za23 23
xa13 4123
zzx 12
a12q 374

 

[LindenWolf]

1 way in D put =MID(B2,1,FIND(" ",B2,1)-1) assuming your row 2 is the start of the data line
Price would be =MID(B2,FIND(" ",B2,1)+1,99)*1


Hope that helps.

 

[Fluff]

How about

+Fluff New.xlsm
	A	B	C	D	E
1		Product ID and Price		Product ID	Price
2		xa1 304		xa1	304
3		za23 23		za23	23
4		xa13 4123		xa13	4123
5		zzx 12		zzx	12
6		a12q 374		a12q	374
Roster

Cell Formulas
Range	Formula
D2:D6	D2	=LEFT(B2,FIND(" ",B2)-1)
E2:E6	E2	=RIGHT(B2,LEN(B2)-FIND(" ",B2))+0

 

[yessir]

Thanks!

 

[Fluff]

Glad we could help & thanks for the feedback.