Excel - Can I Delimit by 2 or more characters? 1

[ElijahBaley]

Hi

I have a single column of data, with each row containing a diiferent text string, however each row does contain the letters ISBN I would like to copy data across to another column from ISBN onwards.

I have tried text to columns but it only allows me to select 1 character with which to delimit the text - any other way of doing this?

Thanks for any help,

EB

 

[DaleWatson123321]

Hi EB,

If your data is in column A, enter the following formula in B1, and copy down for as many rows.

=MID(A1,FIND("ISBN",A1,1)+5,999)

Then convert the formulas to values.

Hope this helps.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[JohnAcc]

If your string data is in column A then type the following formula in column B:

=Mid(A1,5,50)

This will return the 5th character onwards.

Rgds, John

 

[Zathras]

Assuming your data begins in cell A1, you can use this function (e.g., in B1) and copy down as far as you have data:
[blue]

   =MID(A1,FIND("ISBN",A1)+4,999)

[/color]
Then do a copy / paste special values.

(I think Dale's formula is off by one.)

 

[ElijahBaley]

Dale,

=MID(A1,FIND("ISBN",A1,1)+5,999)

This works like a dream!

Thanks for your quick response - much appreciated,

EB