=MID(A1,5,FIND(" ",A1)-1)


"Mattlynn via OfficeKB.com" wrote:

Hi all
I have a list of customers with random text length names, and then 4 spaces
after them, and then some more text.They also all start with 4 numerical
values.
How can i say that i want to just see the text upto the 4 spaces.

i.e
1234BTEnterprises Mr Smith
1234Macdonalds Mrs Smith

I just want the company name (BTEnterprises)

So =if(mid,4, how can i say just the company name when they are all different)


Thanks
Matt

--
Matt Lynn

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200807/1