Previous Topic Next Topic

Find a word in a sentence & paste the same

Closed
Harsha - Jun 16, 2010 at 02:36 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 17, 2010 at 09:32 AM
Hello,
I am new to excel. The task is difficult for me now.

I need to find a particular word from a sentence with the use of wild cards & paste the same word (if found) in another cell.

Eg:
'Server d23bes60 is Down'
I have the above sentence in A1. I need to check if there is any word starting with 'd23' if found i need the out put as 'd23bes60'

Thanks for the reply. Its an urgent case.

Regards,
Harsha
Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 16, 2010 at 07:46 PM
So are you always looking for d23 and if found return d23bes60
Harsha
Jun 17, 2010 at 01:15 AM
Yes, I am always looking for D23.

there are lot of words which starts with D23 eg. d23bes60, d23bes23, d23bes54, d23bes91, d2311111.

So i need a formula to pick the word from a sentence which starts from D23....

Thanks for ur response.
Harsha
Jun 17, 2010 at 03:52 AM
Another Clause:

If there is no word starting with "D23" then the output should come as "0" or "NA"
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 17, 2010 at 08:46 AM
Could you give more example.

what if it is like
'Server HJSd23bes60 is Down'

etc
so would data be always like

....<space>d23.......<space>....
Harsha
Jun 17, 2010 at 09:00 AM
The domino server at is responding slow.
The domino server at d23dbl64 is responding slow.
CNCT DTLS: 072207-744 - DEL-DLFSILO - mail Delay in d23ml181 and d23ml065
IBM:-d23bes60:The Domino Server CN=d23bes60/OU=23/OU=G/O=IBM is down
IBM:inapps06:The Domino Server CN=d23dbl62/OU=23/OU=A/O=IBM is down
IBM:-d23bes60:-d23bes60 is Down. Also d23bes77 & d23bes12
IBM:d23bes60:The Domino Server CN=d23bes60/OU=23/OU=G/O=IBM is down
IBM:-d23bes60:-d23bes60 is Down.
The domino server at responding slow.
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 17, 2010 at 09:32 AM
So if thei line is

IBM:-d23bes60:The Domino Server CN=d23bes60/OU=23/OU=G/O=IBM is down

Should it return some thing or ignore ?

if answer is ignore, then what about my other part of the question, that is
so would data be always like

....<space>d23.......<space>....

Similar discussions

Can no longer paste text into insta
6hypnone -
Gordon -

7 responses