I wonder if you can help me with this two matters:

1.- I have the description "WATER" in the cell "A1". How can I make appear
just the first letter "W" in the cell "B1"?.
2.- In addition, I have the name "Mike Lazo" in the cell"A2". How can I make
appear just the initials "ML" in te cell"B2"?

Thanks in advance.

Simply use the function LEFT.

The second question is more complicated.
I have to figure that out.

--
Regards;
Mark Rosenkrantz
--
Spreadsheet Solutions
Uithoorn
Netherlands (Those who live some 18 feet below sea level)
--
E: (E-Mail Removed)
W: www.spreadsheetsolutions.nl
--

"Maperalia" <(E-Mail Removed)> wrote in message
news:E41BB77F-2ACA-4AB6-AA01-(E-Mail Removed)...
>I wonder if you can help me with this two matters:
>
> 1.- I have the description "WATER" in the cell "A1". How can I make appear
> just the first letter "W" in the cell "B1"?.
> 2.- In addition, I have the name "Mike Lazo" in the cell"A2". How can I
> make
> appear just the initials "ML" in te cell"B2"?
>
> Thanks in advance.

Hi Maperalia,

In Excel2003 I have created the function below.
Add this to a module of your workbook and use it in B1 and B2

Public Function FirstLettersOnly(phrase As String) As String
Application.Volatile
Dim varSplit As Variant
Dim strResult As String
Dim intLoop As Integer

varSplit = Split(phrase, " ")

For intLoop = LBound(varSplit) To UBound(varSplit)
strResult = strResult & Left(varSplit(intLoop), 1)
Next

FirstLettersOnly = strResult
End Function


HTH,

Wouter

For #2 If you don't want to use a macro or custom function this will work
for B2
=CONCATENATE(LEFT(A2,1),MID(A2,FIND(" ",A2)+1,1))

This will not work properly if there is more than one space between the
first and last name.


"Maperalia" wrote:

> I wonder if you can help me with this two matters:
>
> 1.- I have the description "WATER" in the cell "A1". How can I make appear
> just the first letter "W" in the cell "B1"?.
> 2.- In addition, I have the name "Mike Lazo" in the cell"A2". How can I make
> appear just the initials "ML" in te cell"B2"?
>
> Thanks in advance.

Paul;
Thanks for the formula .It is working PERFECTLY!!!!.
I wonder if you can help with my first question I have tried with this
formula =CONCATENATE(LEFT(D10,1),1)
However, it is not working. Could you please tell me how to make it work?

Kind regards.
Maperalia

"Paul C" wrote:

> For #2 If you don't want to use a macro or custom function this will work
> for B2
> =CONCATENATE(LEFT(A2,1),MID(A2,FIND(" ",A2)+1,1))
>
> This will not work properly if there is more than one space between the
> first and last name.
>
>
> "Maperalia" wrote:
>
> > I wonder if you can help me with this two matters:
> >
> > 1.- I have the description "WATER" in the cell "A1". How can I make appear
> > just the first letter "W" in the cell "B1"?.
> > 2.- In addition, I have the name "Mike Lazo" in the cell"A2". How can I make
> > appear just the initials "ML" in te cell"B2"?
> >
> > Thanks in advance.

On 16 Gen, 22:41, Maperalia <Mapera...@discussions.microsoft.com>
wrote:
> Paul;
> Thanks for the formula .It is working PERFECTLY!!!!.
> I wonder if you can help with my first question I have tried with this
> formula =CONCATENATE(LEFT(D10,1),1)
> However, it is not working. Could you please tell me how to make it work?
>
> Kind regards.
> Maperalia
>

Hi Maperalia.

Only: =LEFT(D10,1)

Use the Help on line to verify: =CONCATENATE() and =LEFT()

Regards
Eliano

Thanks very much for your help!!!

"Spreadsheet Solutions" wrote:

> Simply use the function LEFT.
>
> The second question is more complicated.
> I have to figure that out.
>
> --
> Regards;
> Mark Rosenkrantz
> --
> Spreadsheet Solutions
> Uithoorn
> Netherlands (Those who live some 18 feet below sea level)
> --
> E: (E-Mail Removed)
> W: www.spreadsheetsolutions.nl
> --
>
> "Maperalia" <(E-Mail Removed)> wrote in message
> news:E41BB77F-2ACA-4AB6-AA01-(E-Mail Removed)...
> >I wonder if you can help me with this two matters:
> >
> > 1.- I have the description "WATER" in the cell "A1". How can I make appear
> > just the first letter "W" in the cell "B1"?.
> > 2.- In addition, I have the name "Mike Lazo" in the cell"A2". How can I
> > make
> > appear just the initials "ML" in te cell"B2"?
> >
> > Thanks in advance.
>
>

Eliano;
Thank you very much for your help.
Maperalia

"eliano" wrote:

> On 16 Gen, 22:41, Maperalia <Mapera...@discussions.microsoft.com>
> wrote:
> > Paul;
> > Thanks for the formula .It is working PERFECTLY!!!!.
> > I wonder if you can help with my first question I have tried with this
> > formula =CONCATENATE(LEFT(D10,1),1)
> > However, it is not working. Could you please tell me how to make it work?
> >
> > Kind regards.
> > Maperalia
> >
>
> Hi Maperalia.
>
> Only: =LEFT(D10,1)
>
> Use the Help on line to verify: =CONCATENATE() and =LEFT()
>
> Regards
> Eliano
>

RadarEye;
Thank you very much for your help.
Maperalia

"RadarEye" wrote:

> Hi Maperalia,
>
> In Excel2003 I have created the function below.
> Add this to a module of your workbook and use it in B1 and B2
>
> Public Function FirstLettersOnly(phrase As String) As String
> Application.Volatile
> Dim varSplit As Variant
> Dim strResult As String
> Dim intLoop As Integer
>
> varSplit = Split(phrase, " ")
>
> For intLoop = LBound(varSplit) To UBound(varSplit)
> strResult = strResult & Left(varSplit(intLoop), 1)
> Next
>
> FirstLettersOnly = strResult
> End Function
>
>
> HTH,
>
> Wouter
>