Grabbing Middle of Cell

[acady]

Hello:

I have need to take "South Beach Food & Wine" from the cell that reads:

ODR JAN11 South Beach Food & Wine National Unearned A/R

I have been trying MID, Right, left, replace, but just can't get it and know there is any easy solution!

Please let me know. Thanks.

A

 

[Trebor76]

Hi acady,

Welcome to the forum!!

Assuming the entry is static and is in cell A1 (change to suit), try this:

=MID(A1,11,24)

HTH

Robert

 

[VBACO]

What are the constants? For example

is the first nine characters something you ALWAYS want to exclude?

 

[acady]

The constant is the first 10 (including the space). The verbage will vary but it will always be the first 10 I want to get ride of.

 

[Trebor76]

So is "Unearned A/R" the rest of the data you wish to remove?

 

[Jonmo1]

The constant is the first 10 (including the space). The verbage will vary but it will always be the first 10 I want to get ride of.

This at least tells us where the string you want BEGINS...

This will remove the first 10 characters...
=REPLACE(A1,1,10,"")

Now, we need some constant method to know where the END of the string you want to retrieve is.

 

[Jonmo1]

Do you have a list of possible substrings to search for?