G
Guest
Hello,
I want to do what I think is an advanced search and replace and I don't know
how to do it. In column a I have a variety of phrases. In column b, c, d,
etc. I have a variety f sentences (each column has exactly the same
sentences). Each sentence has one phrase in common (although the rest of the
sentence is different). I want to replace that prase with each of the
phrases in column a. Let me diagram what I mean:
Column a
young, small boy
young, tall boy
young, small girl
young, tall girl
Etc.
Column b
I was talking with a nice, old man
I was listening to a nice, old man
I was sitting with a nice, old man
Etc.
Column c
I was talking with a nice, old man
I was listening to a nice, old man
I was sitting with a nice, old man
Etc.
I want the end results to be the following:
Column b
I was talking with a young, small boy
I was listening to a young, small boy
I was sitting with a young, small boy
Etc.
Column c
I was talking with a young, tall boy
I was listening to a young, tall boy
I was sitting with a young, tall boy
Etc.
Column d
I was talking with a young, small girl
I was listening to a young, small girl
I was sitting with a young, small girl
Etc.
And so on.
How can I do this? Thanks and be well.
All the best,
Moshe
I want to do what I think is an advanced search and replace and I don't know
how to do it. In column a I have a variety of phrases. In column b, c, d,
etc. I have a variety f sentences (each column has exactly the same
sentences). Each sentence has one phrase in common (although the rest of the
sentence is different). I want to replace that prase with each of the
phrases in column a. Let me diagram what I mean:
Column a
young, small boy
young, tall boy
young, small girl
young, tall girl
Etc.
Column b
I was talking with a nice, old man
I was listening to a nice, old man
I was sitting with a nice, old man
Etc.
Column c
I was talking with a nice, old man
I was listening to a nice, old man
I was sitting with a nice, old man
Etc.
I want the end results to be the following:
Column b
I was talking with a young, small boy
I was listening to a young, small boy
I was sitting with a young, small boy
Etc.
Column c
I was talking with a young, tall boy
I was listening to a young, tall boy
I was sitting with a young, tall boy
Etc.
Column d
I was talking with a young, small girl
I was listening to a young, small girl
I was sitting with a young, small girl
Etc.
And so on.
How can I do this? Thanks and be well.
All the best,
Moshe