ExcelBanter - Extracting from a cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Extracting from a cell (https://www.excelbanter.com/excel-discussion-misc-queries/127874-extracting-cell.html)

Walter H

Extracting from a cell

I need help with a problem of taking info that I place in a cell and
extracting only a portion of it to another cell.

Example: In A1 I want to take the last 6 digits from an entry that is in
D1. the entry in D1 is a combination of alpha and numeric digits and is 17
digits long.

Any ideas?

Thank you.

pinmaster

Extracting from a cell

Hi,

Try:

=RIGHT(D1,6)

HTH
Jean-Guy

"Walter H" wrote:

I need help with a problem of taking info that I place in a cell and
extracting only a portion of it to another cell.

Example: In A1 I want to take the last 6 digits from an entry that is in
D1. the entry in D1 is a combination of alpha and numeric digits and is 17
digits long.

Any ideas?

Thank you.

Walter H

Extracting from a cell

Thank you. I tried your suggestion and it work perfectly.

"pinmaster" wrote:

Hi,

Try:

=RIGHT(D1,6)

HTH
Jean-Guy

"Walter H" wrote:

I need help with a problem of taking info that I place in a cell and
extracting only a portion of it to another cell.

Example: In A1 I want to take the last 6 digits from an entry that is in
D1. the entry in D1 is a combination of alpha and numeric digits and is 17
digits long.

Any ideas?

Thank you.

All times are GMT +1. The time now is 07:14 AM.