excel problem


Posted by shaun davis on July 19, 2001 2:07 PM

Mr. Excel,

I have a few questions about excel.

Question #1
I wanted to take a last name and a first name and combine them without having to use a new cell. Lets say that my last name is in column A and the first is in Column B. I want the end result to be in Column A with them both put together with one space in between the two,and nothing else in any other columns.
Start:
Column A Column B
Davis Shaun

End Result:
Column A
Davis Shaun

Question #2
I also wanted to use the first initial of the first name and the whole last name as one together. For example
My name is Shaun Davis...I want it to be sdavis.

Thanks for your time,

Shaun Davis

Posted by Matt on July 19, 2001 2:23 PM

Shaun, go to this page on Mr. Excel's website for your answer.

http://www.mrexcel.com/tip042.shtml

Matt



Posted by Ian on July 20, 2001 5:55 AM

For the first =b1&" "&a1
for the second =left(b1,1)&a1

hope this is what you want

Ian