You're welcome. Thanks for the feedback!

Biff

"Keenman" <Keenman.26wiwb_1146105302.3133@excelforum-nospam.com> wrote in
message news:Keenman.26wiwb_1146105302.3133@excelforum-nospam.com...
>
> Biff,
>
> Worked great!!! Thanks...
>
>
> Biff Wrote:
>> Hi!
>>
>> One way: (assuming every entry starts with uid= and has at least one
>> comma):
>>
>> =LEFT(SUBSTITUTE(A1,LEFT(A1,4),""),FIND(",",A1)-5)
>>
>> Copy down as needed.
>>
>> Not sure what you intend to do about deleting the formulas but you
>> might try
>> this:
>>
>> Select the range of formulas
>> Goto Edit>Copy
>> Then Edit>Paste Special>Values
>>
>> This will convert the formulas to constants.
>>
>> Then you could delete the original data BUT before you do that make
>> sure the
>> formulas extracted the correct data!
>>
>> Biff
>>
>> "Keenman" <Keenman.26uo8c_1146018902.4268@excelforum-nospam.com> wrote
>> in
>> message news:Keenman.26uo8c_1146018902.4268@excelforum-nospam.com...
>> >
>> > I have a worksheet with data in a column as follows
>> >
>> > uid=xvdcfrd,ou=people,dc=xxxxx
>> > uid=sdsdsd,ou=people,dc=xxxxx
>> > uid=fhjetyv,ou=people,dc=xcxcx
>> >
>> > Each of the above lines is in a single cell in the column. I need
>> to
>> > start at the top cell and retrieve the text following the first =
>> sign
>> > and grab the text to the first comma (in cell one in the above
>> example,
>> > I want xvdcfrd). After retrieving the text I want to copy/move it
>> to
>> > another column (If I delete the formula, I want to keep the
>> retrieved
>> > data unless there is a way to write the data that I retrieve in the
>> > same column that I am performing this function on). I need the code
>> to
>> > loop through the entire column and grab that data from each cell.
>> >
>> > Thanks in advance...
>> >
>> >
>> > --
>> > Keenman
>> >
>> ------------------------------------------------------------------------
>> > Keenman's Profile:
>> > http://www.excelforum.com/member.php...o&userid=14220
>> > View this thread:
>> http://www.excelforum.com/showthread...hreadid=536246
>> >
>
>
> --
> Keenman
> ------------------------------------------------------------------------
> Keenman's Profile:
> http://www.excelforum.com/member.php...o&userid=14220
> View this thread: http://www.excelforum.com/showthread...hreadid=536246
>