Hi Mike,
Please use below mentioned formula and also check attached file for example.
=LEFT(A1,FIND(" ",A1,1))
regards,
Vijay
On Thu, Feb 25, 2010 at 5:10 PM, Mike wrote:
>
>
> On Feb 24, 9:53 pm, Mike wrote:
> > Hi folks,
> > Looking for a function(if it exists) that will grab the first l
On Feb 24, 9:53 pm, Mike wrote:
> Hi folks,
> Looking for a function(if it exists) that will grab the first letter
> in a string and put it in another cell. For example:
>
> '12 Roosevelt Ave.'
>
> Some function that will grab the '12' and put it in another cell, with
> the original cell left
