*Hi Mike,
Simple function like this
12 Roosevelt Ave* *
=RIGHT(A1,14)* *
=LEFT(A1,2)* 12 Roosevelt Ave Roosevelt Ave 12
Hope it can help
Worawat
2010/2/25 Mike
> Hi folks,
> Looking for a function(if it exists) that will grab the first letter
> in a string and put it in another
Check MID function.
Regards,
C.G.Kumar
AMW-2
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Mike
Sent: 25/February/2010 8:23 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Need to grab a word from a string
Hi folks
Dear
Mike here is your solution.
On Thu, Feb 25, 2010 at 8:23 AM, 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
Say Cell A1 is 12 Roosevelt Ave
=VALUE(LEFT(A1,FIND(" ",A1,1)))
Regards,
Viral Pandya
On Thu, Feb 25, 2010 at 8:23 AM, 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.'
$Excel-Macros$$ Need to grab a word from a string
> From: foehamme...@yahoo.com
> To: excel-macros@googlegroups.com
>
> 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 Roos
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 over with just 'Roosevelt Ave.'
I don't kno
