# How to determine the first two carachters in a name

1. ## How to determine the first two carachters in a name

is there a way to deterimine the first two characters in a name for abbrev.

eg. Charlie Brown result =CH
thanks in advance for any help

2. ## =Left

If the name is in cell A1:

=Left(A1,2) will return the two leftmost characters.

similarly Right (A1,2) will give you the last two characters.

If you want to locate characters in the middle of a name, or any other string, use =MID

e.g. =MID(A1,2,2) will give you the second and third characters in the string.

3. great. here i have one question for you that i need to remove space between two words in same cell(A1) eg; K OSTAS CON STAN TINOU result should be KOSTASCONSTANTINOU. is it possiable thing??

thanks
ckc.

4. ## Re: How to determine the first two carachters in a name

This in fact did thank you for your time and effort

"CaptainQuattro" wrote:

>
> If the name is in cell A1:
>
> =Left(A1,2) will return the two leftmost characters.
>
> similarly Right (A1,2) will give you the last two characters.
>
> If you want to locate characters in the middle of a name, or any other
> string, use =MID
>
> e.g. =MID(A1,2,2) will give you the second and third characters in the
> string.
>
>
> --
> CaptainQuattro
> ------------------------------------------------------------------------
> CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763
>
>

5. Hi ckc!

its easy to do. just select cell A1
press Ctrl+H, it will open find and replace window.
in Find what: just press space bar
and leave Replace with: empty. and at last press replace.
where are the spaces...

you can also use a formula to do this
=substitute(A1," ","")

6. ## Re: How to determine the first two carachters in a name

=SUBSTITUTE(A1," ","")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"ckc_2k" <[email protected]> wrote in
message news:[email protected]...
>
> great. here i have one question for you that i need to remove space
> between two words in same cell(A1) eg; K OSTAS CON STAN TINOU result
> should be KOSTASCONSTANTINOU. is it possiable thing??
>
> thanks
> ckc.
>
>
> --
> ckc_2k
> ------------------------------------------------------------------------
> ckc_2k's Profile:

http://www.excelforum.com/member.php...o&userid=33553
>

7. ## Re: How to determine the first two carachters in a name

Another way if you have lots to do and don't want to use formulas in helper
cells.

Select the range
edit|replace
what: (spacebar)
with: (leave blank)
replace all

ckc_2k wrote:
>
> great. here i have one question for you that i need to remove space
> between two words in same cell(A1) eg; K OSTAS CON STAN TINOU result
> should be KOSTASCONSTANTINOU. is it possiable thing??
>
> thanks
> ckc.
>
> --
> ckc_2k
> ------------------------------------------------------------------------
> ckc_2k's Profile: http://www.excelforum.com/member.php...o&userid=33553

--

Dave Peterson

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1