Placing Periods in Excel

S

sconley1

New Member
Joined
Jan 19, 2018
Messages
6
I am trying to place a period after a middle initial and after a title. =A1&"." works however some don't have a middle initial or the name is spelled out so I do not want a period there. Any help with this would be very much appreciated!




Column A Column B Column C Column D

Mr Jo Henry Smith
Mark W Walsh
Mrs Ashley Beall
 
Sort by date Sort by votes
I'm sorry your right. The above formula worked. When I run the original report it put the rank last (column D) instead of first (Column A) and I did not change that prior. Thank you all for your help I really appreciate it.
 
Upvote 0

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
You must log in or register to reply here.

Similar threads

M
  • Question Question
How to split a full name in 1 column into 2 columns (C1 - First name, C2 - Last name (*but here's the tricky - what if there's a middle initial?
Replies
6
Views
318
Mavericx
M
A
  • Solved
Using VBA to loop through multiple Word Templates and fill them in with Excel Data
2
Replies
14
Views
1K
John_w
J
A
  • Solved
Comparing two excel files for matching / mismatching rows (long text strings - match() wont work
Replies
4
Views
941
ahaye
A
C
  • Question Question
Need to add to my search worksheet
Replies
1
Views
100
craigwojo
C
A
  • Solved
Fill down formulas and Do Until "No more data"
Replies
4
Views
1K
felixstraube
F

Forum statistics

Threads
1,223,228
Messages
6,170,871
Members
452,363
Latest member
merico17

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top