More excel formulas needed please 1

[JimmyRosa]

Hi all

I need to upload user data to office 365

1 of the fields needs data from columns B & C. B = first name 'joe' and c = second name 'bloggs'
column d = the display name that I need. e.g 'joe bloggs'

The next 1 is more tricky well for me anyway.

Column p2 has a email address e.g @domain.org which also needs data from columns b & c. which will display in column a as e.g bloggs_j@domain.org


I take it once I have created these formulas successfully, I can just copy these down columns 'c' for the display name
and column 'a' for the email address? How do then execute for all?



I have tried but started to mess up the spread sheet, I will be honest I'm not great in excel and would really appreciate if someone could help me please?


Kind regards
JR

 

[1726]

Assuming first data row is row 2:

Name: =B2&" "&C2

You could ensure proper name case with: =PROPER(B2&" "&C2)

For the email address it is not clear what punctuation you need between initial and surname - since it cannot be a space, so change the punctuation in the following to suit your needs.

Address: =C2&"."&LEFT(B2,1)&"@domain.org"

You could ensure a lowercase e-mail address using: =LOWER(C2&"."&LEFT(B2,1)&"@domain.org")

cheers

 

[JimmyRosa]

Thanks 1726!


Quick precise and optional response.

I really do appreciate it, thanks very much for your help and in the past. I will these formula's definitely come in handy!

J