Oct 18, 2024
6:43:54am
6:43:54am
Before I Google it, I thought I'd ask CougarBoard excel Gurus. Is there a way to add an * before the content
in every cell of a column?
I am importing a list of 110 test questions to program and I have to specify the correct answer.
I forgot to do that when I created the list.
So I am hoping there is a way I can tell excel to add an * at the start of every cell without deleting the content.
I am sure I can just hand jam it in the time it would take me to search out the answer, but it's always fun learning a new trick if it's possible.
I am importing a list of 110 test questions to program and I have to specify the correct answer.
I forgot to do that when I created the list.
So I am hoping there is a way I can tell excel to add an * at the start of every cell without deleting the content.
I am sure I can just hand jam it in the time it would take me to search out the answer, but it's always fun learning a new trick if it's possible.
- Previous username
- Kirkintilloch
- Bio page
- JayOwen
- Joined
- Jul 31, 2004
- Last login
- Dec 23, 2024
- Total posts
- 42,510 (27,394 FO)
Messages
Time
Before I Google it, I thought I'd ask CougarBoard excel Gurus. Is there a way to add an * before the content
Oct 18, 6:43am
In the cell next to the first row: ="*"&A1 (A1 being the cell reference that has the text) then copy down
Oct 18, 6:45am
Oct 18, 6:46am
Oct 18, 6:47am
Oct 18, 7:42am