Extracting data

[mahmed1]

Hi

what formula can i have to extract 4,5,6,7 characters from a range
The range contains letters and numbers

123hgf456
4567

row numbers
4,5,6,7
what i need is to look at 123hyf456
and extract the 4,5,6,7 characters

the mid function allows to extract only one character but i need all those characters

thanks

thanks

 

[pgc01]

Hmmm...

Maybe I'm not understanding what they want to do.

My interpretation is they want to EXTRACT the characters at specific character positions.

Sort of like this (if it were possible):

A1 = ABCDEFGHI

=MID(A1,{3,4,7,9},1)

And the expected result is CDGI

Thank you Biff. I think you are right and I messed up completely.

In fact now I read the thread with attention and Mahmed has even mentioned that he already knew how to delete the digits replacing them with blanks.

Sorry Mahmed.

If what you want is, like Biff said, to concatenate just an array of specific positions of a string, in that case, for a general solution I agree that it should be vba.

If your strings have a maximum number of characters that your previously know, then I guess you can also have a formula (maybe with auxilliary formulas) and you can do the same as I posted but deleting characters in specific positions (all but the ones in your array).

 

[mahmed1]

Thank you all for your help

much appreciated,

if you guys are ever in around the birmingham area in england i will treat you to a curry on the house in one of my restaurants