pulling certain characters from a string of text
Hi,
=left(a1,3)
"SaraMack" wrote:
I need to look up "certain critera" within a string of characters, then
return that "certain criterea" to a new column.
Some examples of a strings of characters may look like these:
K5J091509001
Sample PO#S881009
K55sample PO
CarrieRJR
TJ5
My "Certain Critera" I have listed on another sheet, named "REP ID"
K5J
S88
K55
RJR
TJ5
How do I pull out the 3 characters of "Certain Criterea" from the string of
text and copy or enter it into a new column?
|