copying only part of a cell

[jbrown021286]

Jeffs Tech Flag Sheet.xlsx
	A	B	C	D	E
1			Tech Flag Sheet
2		Tech Name and employee number		Jeffrey Brown 101502
3		Tag/RO Number	Sold Hours	Date	Advisor
4	1hgcr2f86ga094757
5	shhfk7h69lu223373
6
7
8
6.26 (2)

Cell Formulas
Range	Formula
D4:D8	D4	=IF(B4<>"",IF(D4="",TODAY(),D4),"")

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A4:A5	Expression	=COUNTIF(S:S,A4)>0	text	NO

i have got a sting of numbers in collum A and i need to copy only the last 8 characters of ech of those to the adjacent cells in column B. is it possible to make a formula to achieve this objective?

 

[Joe4]

In cell B4, just use this formula:

=RIGHT(A4,8)

and copy down for all rows.

 

[Special-K99]

=RIGHT(A4,8)

 

[jbrown021286]

In cell B4, just use this formula:

=RIGHT(A4,8)

and copy down for all rows.

that got it thanks

 

[Joe4]

You are welcome.
Glad we could help!