Adding a period to the "=LEFT()" function.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am converting a list of names to first initials using the =LEFT() function,
but can't figure out how to add a period afterthe first initial?

Is there a way to adjust this formula, or another one that would add a period?

Thanks so much.

Stilla
 
=left(a1,1) & ". " & b1

maybe???


I am converting a list of names to first initials using the =LEFT() function,
but can't figure out how to add a period afterthe first initial?

Is there a way to adjust this formula, or another one that would add a period?

Thanks so much.

Stilla
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating percentage growth rate from a cumulative figure 4
Double space - period shortcut? 2
Two question on working with text 2
FIND from right to left instead of left to right 8
Calculating number of periods 2
is 3rd character in a cell a space? 5
Removing a period and leaving maintaingn a fixed #of numbers 5
Excel Formula Help 2

Back
Top