Formula for Displaying the First Character of a word
 

Is there a formula (or macros) that grabs the first character of a string of
text??

For example I have the following columns: Column A (Last name) Smith, Column
B (First name) Heather. In column C i want the first Character of Column B so
in this case it would be H.

Any suggestions? Thanks in advance

Formula for Displaying the First Character of a word
 

savbci, =LEFT(B1,1)
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"savbci" wrote in message
...
Is there a formula (or macros) that grabs the first character of a string
of
text??

For example I have the following columns: Column A (Last name) Smith,
Column
B (First name) Heather. In column C i want the first Character of Column B
so
in this case it would be H.

Any suggestions? Thanks in advance

Formula for Displaying the First Character of a word
 

=LEFT(B1,1)

and copy down

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk


"savbci" wrote in message
...
Is there a formula (or macros) that grabs the first character of a string
of
text??

For example I have the following columns: Column A (Last name) Smith,
Column
B (First name) Heather. In column C i want the first Character of Column B
so
in this case it would be H.

Any suggestions? Thanks in advance

Formula for Displaying the First Character of a word
 

Use:

=LEFT(B1,1)

and copy down. This takes the left part of the string, the number of
characters being governed by the 1.

Hope this helps.

Pete

Formula for Displaying the First Character of a word
 

Left(Value, Number of characters)

Left(B1,1)

--
Kevin Backmann


"savbci" wrote:

Is there a formula (or macros) that grabs the first character of a string of
text??

For example I have the following columns: Column A (Last name) Smith, Column
B (First name) Heather. In column C i want the first Character of Column B so
in this case it would be H.

Any suggestions? Thanks in advance