Copy in other cell just one letter.

M

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.
 
S

Spreadsheet Solutions

Simply use the function LEFT.

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

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
 
P

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.
 
M

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
 
E

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
Click to expand...

Hi Maperalia.

Only: =LEFT(D10,1)

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

Regards
Eliano
 
M

Maperalia

Thanks very much for your help!!!

Spreadsheet Solutions said:
Simply use the function LEFT.

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