Quick Excel Problem - Look and Return first letter of a cell. 1

[SteveAudus]

I've got a list of names, and I need a list of first initial.

What command do I use to look at a cell and return the first letter of the names.

Thanks for your help
Steve Audus
Chaucer School
Sheffield, UK

http://www.chaucer.sheffield.sch.uk

http://www.educationinternet.co.uk

 

[PepeLeMokko]

Use left(cell,1)

 

[PepeLeMokko]

Use left(cell,1)

 

[SteveAudus]

Thanks Coyoteooc,
excellent, could you please add how I would add their surnames to the list now, so I have the result, intial.surname in one cell?

Thanks again
Steve Audus
Chaucer School

http://www.chaucer.sheffield.sch.uk

http://www.educationinternet.co.uk

 

[xlbo]

1: How do the names look at the moment ??
2: Are they in a consistent format ?
3: What seperates first name and last name ?
4: Are there any instances of middle names etc that may throw out a formula ?? Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde

 

[SteveAudus]

I have a list of firstname in one column and surnames
in another.
I like a column of intial.surname

Thanks for your help
Steve Audus
Chaucer School

http://www.chaucer.sheffield.sch.uk

http://www.educationinternet.co.uk

 

[SteveAudus]

Sorted out don't worry I found the
CONCATENATE command.

Thanks all,
Steve Audus

http://www.chaucer.sheffield.sch.uk

http://www.educationinternet.co.uk

 

[xlbo]

Steve - just as a tip, you don't actually need the concatenate function.
Assuming fist names in colA and surnames in colB
=Left(A1,1)&"."&B1
will do the same as the concatenate function Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde