Find a substring

  • Thread starter Thread starter cirudinezidane
  • Start date Start date
C

cirudinezidane

Hi!

I would like to find a substring from a column. I have a column with a
identification code and in other column I have other hash code with
the identification code. I would like to match these columns and to
obtain hash code. An examle

ID ID+HASH RESULT
123 987_123 987
654 8D8_654 8D8


How I can obtain this result?


Thanks
 
=SUBSTITUTE(B1,A1&"_","")

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find Text String 5
Accessing substrings quickly 5
Find a value in a sheet and replace it with another value if it matches 8
search text for substring and change text colour of substring 5
macro to find numeric data & move it 2
Auto fill for dates? 2
How do I set auto-sort for a column in a worksheet? 6
MD5 -- can I use one from somewhere? 2

Back
Top