Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel formula

Status
Not open for further replies.
cwissy

cwissy

IS-IT--Management
Nov 16, 2003
103
AU
Trying to create a list of usernames for import into Microsoft 2003 server. I have an excel spreadsheet with firstname, lastname and want to combine the first character of the firstname and the whole of the surname into one cell, can anyone help?
 
Sort by date Sort by votes
+concatenate(left(A1,1)," ",B1)

where firstname is in cell A1, and lastname is in cell B1


Pete Bloomfield
Down Under
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

arvarr
  • Locked
  • Question
Excel Formula Help 1
Replies
7
Views
387
SkipVought
S
PSchubert
  • Question
Excel: Formula only works with certain numerical values
Replies
12
Views
540
dhookom
dhookom
TomSalvato
  • Locked
  • Question
EXCEL-formula help 2
Replies
6
Views
237
TomSalvato
TomSalvato
Andrzejek
  • Question
Formula with & and a single quote 2
Replies
4
Views
504
OzFoxy
OzFoxy
renigar
  • Question
Having trouble with Excel Lookup
Replies
5
Views
432
renigar
renigar

Part and Inventory Search

Sponsor

Back
Top