<div>
Hi shwelopo,<br />
<br />
I suggest you be more descriptive with your question titles, in future. &nbsp;Something which allows experts to see something more than just the topic area, when they look at the summarised list of questions. &nbsp;Experts often just look down a list of titles and topic areas, to see whether this is a question they want to look at, so you can make it easier for experts if you choose a title carefully. &nbsp;For example, something like: &quot;Applying Excel formula to many rows&quot; might have been better in this case.<br />
<br />
Thanks.
</div>


Hi shwelopo,

I suggest you be more descriptive with your question titles, in future.  Something which allows experts to see something more than just the topic area, when they look at the summarised list of questions.  Experts often just look down a list of titles and topic areas, to see whether this is a question they want to look at, so you can make it easier for experts if you choose a title carefully.  For example, something like: "Applying Excel formula to many rows" might have been better in this case.

Thanks.

<div>
<div class="content wysiwyg-content">
I have this formula for excel and I'd like to run it one time for over 300 names to create usernames. &nbsp;pls help.<br />
<br />
<br />
=CONCATENATE(LEFT(B1,1), C1)
</div>
</div>


I have this formula for excel and I'd like to run it one time for over 300 names to create usernames.  pls help.


=CONCATENATE(LEFT(B1,1), C1)

excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.