function please
JG:
Try this formula in the uppermost cell of the column you want the #'s to appear in and just autofill it down the column. =LEFT(A1,FIND(" ",A1)-1) |
All times are GMT +1. The time now is 12:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com