Adding character before text in Excel without using formula

Question

I want to add a prefix before a text without using formula, without linking to another cell. So that I can directly type in the text in a single cell but showing with a prefix. Something similar to ("new" #) in the custom format if using number. Possible to achieve using custom format only?

I've tried to use "new" # in custom but this is only applicable for numbers. Typing in text will return the text that I've typed.

I expected to type "book" but the cell should show as "new book".

Rory · Accepted Answer · 2019-06-20 11:42:30Z

2

Use:

"new" @

as a custom format.

answered Jun 20, 2019 at 11:42

Rory

34.2k5 gold badges40 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Adding character before text in Excel without using formula

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related