software

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


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: www.excelforum.com/member.php...oamp;userid=32763
View this thread: www.excelforum.com/showthread...hreadid=533357
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: www.excelforum.com/member.php...oamp;userid=33553
View this thread: www.excelforum.com/showthread...hreadid=533357This in fact did thank you for your time and effort

quot;CaptainQuattroquot; wrote:

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


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,quot; quot;,quot;quot;)--
starguy
------------------------------------------------------------------------
starguy's Profile: www.excelforum.com/member.php...oamp;userid=32434
View this thread: www.excelforum.com/showthread...hreadid=533357=SUBSTITUTE(A1,quot; quot;,quot;quot;)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;ckc_2kquot; gt; wrote in
message ...
gt;
gt; great. here i have one question for you that i need to remove space
gt; between two words in same cell(A1) eg; K OSTAS CON STAN TINOU result
gt; should be KOSTASCONSTANTINOU. is it possiable thing??
gt;
gt; thanks
gt; ckc.
gt;
gt;
gt; --
gt; ckc_2k
gt; ------------------------------------------------------------------------
gt; ckc_2k's Profile:
www.excelforum.com/member.php...oamp;userid=33553
gt; View this thread: www.excelforum.com/showthread...hreadid=533357
gt;
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:
gt;
gt; great. here i have one question for you that i need to remove space
gt; between two words in same cell(A1) eg; K OSTAS CON STAN TINOU result
gt; should be KOSTASCONSTANTINOU. is it possiable thing??
gt;
gt; thanks
gt; ckc.
gt;
gt; --
gt; ckc_2k
gt; ------------------------------------------------------------------------
gt; ckc_2k's Profile: www.excelforum.com/member.php...oamp;userid=33553
gt; View this thread: www.excelforum.com/showthread...hreadid=533357

--

Dave Peterson