-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
My excel knowledge is very basic unfortunately & I would like to add but the number of surnames with the same first initial
- Thread starter jomowens
- Start date
Kaper
Well-known Member
- Joined
- Mar 14, 2014
- Messages
- 772
- Office Version
- 365
- Platform
- Windows
So after that you would like to have for instance:
and so on?
Assuming ALLOT is in cell A1, in cell B1 write:
copy this down (easiest way will be by selecting this cell and double click on "fill handle" - a small black square in bottom-right corner of selected cell.
Now you can select the cells with these formulas (only if you moved the active cell, if you not moved all cells are still selected) copy (ctrl+V) and paste special as values (probably Ctrl+Shift+V will do the job, but you could also select paste as values from Paste icon in Main card
| A. ALLOTT |
| A. BARNARD |
Assuming ALLOT is in cell A1, in cell B1 write:
Excel Formula:
="A. " & A1Now you can select the cells with these formulas (only if you moved the active cell, if you not moved all cells are still selected) copy (ctrl+V) and paste special as values (probably Ctrl+Shift+V will do the job, but you could also select paste as values from Paste icon in Main card
Upvote
0
Kaper
Well-known Member
- Joined
- Mar 14, 2014
- Messages
- 772
- Office Version
- 365
- Platform
- Windows
You are welcome.
But probably this case shows, that it's a good time to spend few hours on some "basic excel course" - there are even some for free. But don't ask me for recommendations which are the best for beginners - I don't have such knowlegde.
But probably this case shows, that it's a good time to spend few hours on some "basic excel course" - there are even some for free. But don't ask me for recommendations which are the best for beginners - I don't have such knowlegde.
Upvote
0
