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
0
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.
0
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"
0
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>....
0
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.
0
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>....
0

Similar discussions

How to convert the tamil pdf file to tamil word file
varathalakshmi -
karthik -

12 responses
Can no longer paste text into insta
6hypnone -
Richierichmeister -

6 responses