Mid Function
 

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

Mid Function
 

Try this:

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

HTH,

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


"Mattlynn via OfficeKB.com" <u44078@uwe wrote in message
news:8730015fa9dd6@uwe...
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

Mid Function
 

=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