Home » » Add some word to all or some rows in MS Excel?

Add some word to all or some rows in MS Excel?


If I want to add some words before or after each word of a column, how can I do that?
Ex:
Lora
Muhit
Jana
Devid
John
Kanon
Rivery

I mean: for example, I put the words "who is" before each number in the first column and get

Who is Lora
Who is Muhit
Who is Jana
Who is Devid
Who is John
Who is Kanon
Who is Rivery

Solution:
The easiest way is:

  • Select All cells that want to change.
  • right click and select Format  cell.
  • In category select Custom.
  • In Type select General and insert this format ----> "Who is "@
Add some word to all or some rows in Excel?

Add some word to all

0 comments:

Post a Comment