Home

Autocopy numeric values

%3CLINGO-SUB%20id%3D%22lingo-sub-866965%22%20slang%3D%22en-US%22%3EAutocopy%20numeric%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-866965%22%20slang%3D%22en-US%22%3E%3CP%3E%22A%22%3C%2FP%3E%3CP%3EJohn%201%3CBR%20%2F%3EPeter%202%3CBR%20%2F%3EElvis%203%3CBR%20%2F%3EJoan%204%3C%2FP%3E%3CP%3EAnd%20so%20on%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20lot%20of%20data%20i%20column%20A%20ending%20with%20a%20numeric%20value.%20I%20need%20to%20copy%20the%20numeric%20value%20(NOT%20the%20name)%20to%20neighbor%20cell%20in%20column%20%22B%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-866965%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-866981%22%20slang%3D%22en-US%22%3ERe%3A%20Autocopy%20numeric%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-866981%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F412359%22%20target%3D%22_blank%22%3E%40PEP1958%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20the%20pattern%20in%20column%20A%20is%20always%20a%20name%20in%20single%20word%20followed%20by%20a%20space%20and%20then%20a%20number%2C%20assuming%20your%20string%20is%20in%20A2%2C%20then%20try%20this...%3C%2FP%3E%3CP%3E%3DRIGHT(A2%2CLEN(A2)-FIND(%22%20%22%2CA2))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20564px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F132759i3DE7B53D228E225C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22SplitNumber.jpg%22%20title%3D%22SplitNumber.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EOr%20you%20can%20also%20use%20the%20Text%20to%20Columns%20feature%20under%20the%20Data%20tab%20and%20use%20space%20as%20a%20delimiter%20and%20your%20names%20will%20remain%20in%20column%20A%20while%20the%20numbers%20will%20be%20extracted%20into%20column%20B.%3C%2FP%3E%3C%2FLINGO-BODY%3E
PEP1958
Occasional Visitor

"A"

John 1
Peter 2
Elvis 3
Joan 4

And so on

 

I have a lot of data i column A ending with a numeric value. I need to copy the numeric value (NOT the name) to neighbor cell in column "B"

 

 

 

 

1 Reply

@PEP1958 

If the pattern in column A is always a name in single word followed by a space and then a number, assuming your string is in A2, then try this...

=RIGHT(A2,LEN(A2)-FIND(" ",A2))

 

SplitNumber.jpg

Or you can also use the Text to Columns feature under the Data tab and use space as a delimiter and your names will remain in column A while the numbers will be extracted into column B.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies