Extracting Text

[huntersdad]

Hello all. I need to extract the characters from a text string in several cells. Each cell has 78 characters in them.I need the characters from 45 and 61. Any suggestions? Thanks.

[Colin Legg]

Hi,

This will give you the 45th character:
=MID(A1,45,1)

This will give you the 61st character:
=MID(A1,61,1)

This will give you the 45th through to 61st characters (inclusive):
=MID(A1,45,17)

[ChemistB]

So you need the 45th and 61st characters (or 45 to 61)?
If the first

=MID(A1,45,1)&MID(A1,61,1)
Does that work for you?