Mid Function

[Mattlynn via OfficeKB.com]

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

 

[RagDyeR]

Try this:

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

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


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

 

[Teethless mama]

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