Advertisement

06.06.2008 at 11:44AM PDT, ID: 23464684
[x]
Attachment Details

How to merge certain data from one cell to another

Asked by dsheltzel in Microsoft Excel Spreadsheet Software, Microsoft Office Suite, Microsoft Applications

Tags: , ,

I have an Excel SS - I need to take the data from one cell and merge with the second cell. The problem is, I only need the first letter of the data in cell one. How do i do this. I tried this formula but it didnt work

=LEFT(A,1)&B5

In the first column are first names, and in the second column there are last names
So from Brian Smith I want to create bsmith.

Please help!

Thanks!Start Free Trial
[+][-]06.06.2008 at 11:53AM PDT, ID: 21731790

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.06.2008 at 12:00PM PDT, ID: 21731837

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.06.2008 at 12:07PM PDT, ID: 21731896

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Microsoft Excel Spreadsheet Software, Microsoft Office Suite, Microsoft Applications
Tags: Microsoft, Excel, 2007
Sign Up Now!
Solution Provided By: rlistenb
Participating Experts: 2
Solution Grade: A
 
 
[+][-]06.06.2008 at 02:22PM PDT, ID: 21732802

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628