Hello,
I am trying to figure out a way to automatically copy the first word of a cell and then replace a certain character (~ or -) in the same cell with that word. Also, I would like this to be done automatically in all cells from that sheet. Would this be possible to achieve with only excel?
Thanks and best regards!
P. S. If my explanation is a bit blurry, I will try to give a picture with an example of what I'm trying to do.
I am trying to figure out a way to automatically copy the first word of a cell and then replace a certain character (~ or -) in the same cell with that word. Also, I would like this to be done automatically in all cells from that sheet. Would this be possible to achieve with only excel?
Thanks and best regards!
P. S. If my explanation is a bit blurry, I will try to give a picture with an example of what I'm trying to do.