View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Retrieving Part of a Cell Contents

Try this

=MID(A1,SEARCH("_",A1)+1,LEN(A1))

Mike

"Minitman" wrote:

Greetings,

I have a column of text that has a "_" in the middle of the text.
This "_" is in different places in these cells. I want to get all of
the text after these "_" and have it show up in the adjacent cells.

I took a look at Left, Right and Mid, but they don't seem to be able
to start with a character only a position.

Is there anyway to use a character to start character retrieval
instead of position?

Any help would be appreciated.

-Minitman