*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.'
Hi,
Conflicting info.
First you say you want to extract just the first letter, then you say you want
the first 2 digits.
Please clarify.
But look in the Help for info on the LEFT function. It may be what you need.
Regards - Dave.
> Date: Wed, 24 Feb 2010 18:53:18 -0800
> Subject: $$Excel-M
