How to create formula in excel?

Question

I want to basically make one column like this {(CellA).(cellB)@(cellC).com} I am totally lost when it comes to excel someone please help!!

Answer 1

It's not clear from what you describe what it is you want to do.  Try using the online help menu.  I've never seen syntax like this in an Excel formula.

Answer 2

I assume from your description you're trying to combine the contents of 3 cells, together with the . @ com.  Just do this

assuming your 3 cells are A1, B1, C1

=A1&"."&B1&"@"&C1&".com"

when adding (concatinating) strings together use the & symbol.  And manually typed strings must be in " " double-quotes

-----------more-------------->>>

if you only want the first letter of a cell just use the LEFT() function.

for example =LEFT(A1, 1) tells excel to return the first character of A1 starting from the left.

so you can do:

=LEFT(A1,1)&"."&B1&"@"&C1&".com"

hope that helps...and hope it's worth a "best answer" :-)))))