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

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

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

=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

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