Copy in other cell just one letter.

[Maperalia]

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.

 

[Spreadsheet Solutions]

Simply use the function LEFT.

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

 

[RadarEye]

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

 

[Paul C]

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]

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

 

[eliano]

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

 

[Maperalia]

Thanks very much for your help!!!

Simply use the function LEFT.

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

 

[Maperalia]

Eliano;
Thank you very much for your help.
Maperalia

 

[Maperalia]

RadarEye;
Thank you very much for your help.
Maperalia