If I want to add some words before or after each word of a column, how can I do that?
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
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 "@