Add Letter To Existing Text in a Cell

[richramik1]

Hey Gang:

I have a cell with alphabetic content. What I want to do is add the letter P to the end of the alphabetic content in the same cell.

Example: Cell A1 has an alphabetic content of ABC-ZZ. I want to add the letter P to the end of the content in cell A1. When completed, the content of cell A1 would be ABC-ZZP.

Thanks In Advance,
Rich Ramik

[Villeroy]

Hit F2, type letter P, hit Enter or Tab or some arrow key.

[Lupp]

You (@richramik1) surely don’t ask how to do this for a single cell.

If you want to do it for many cells ´, you need to make clear, how the multitude of cells you need to process shall be delimited.

• The current selection?
• All cells having direct textual content?
• Even cells with a number as content? (Would change the type!)
• Even cells showing a formula result? (Would change the type!)
• In a different way…

Or do you actually want to get the result in a different cell?

Please try to ask clear (sufficiently detailed though concise) questions. Making volunteers guess and by that waste their time surely isn’t your aim.

[robleyd]

Use Find and Replace with regular expressions.

• Select the cells to modify
• Open the Find and Replace dialog
• In Find, put .*
• In Replace, put &P
• Under More Options, select Current Selection Only and Regular Expressions
• Choose Values for Search In
• Click Replace All

[eeigor]

@robleyd

• In Find, put .*
• In Replace, put &P

Or:

$ sign marks the end of the line (insertion point).

[eeigor]

E.g. A1: =ABC-ZZ

1. Enter in B1: =CONCAT(A1;“P”)
2. Copy the data to the clipboard: Select B1 cell, press Ctrl+C
3. Paste Special (to replace a formula with a value): Press Ctrl+Shift+V, insert values only
4. Delete the first column (A)

Similarly, for a range of cells.
Edit:
It was assumed that the questioner still simplifies the task and wants to get a non-direct answer to such a primitive question, which was best answered by @Villeroy.

[LeroyG]

Beware of the use of curly quotation marks in the formula (at least not working in my environment).
Instead of Ctrl+C and Ctrl+Shift+V + values, try menu Data - Text to Columns.