Selection of Characters

I

ianripping

In Row A I have this information

1234 5486 5414 4781
0245 2354 5489 5642
1230 4567 4987 1253

I want to copy this information into column B but only the last 1
digits of each cell in column A.

So it would look like this in column B

5486 5414 4781
2354 5489 5642
4567 4987 1253

Any ideas
 
F

Frank Kabel

Hi
=RIGHT(A1,12)

though if i look at your example it seems that there are spaces between
your digits. so maybe you have to change the formula to
=RIGHT(A1,14)

Frank
 
J

John Wilson

ianripping,

Try this in Column B

=RIGHT(A1,14)

The 14 includes the two spaces in your number string.

John
 
F

Flemming Dahl

Hey

If you don't know where the first space is, then you can use this one:

=RIGHT(A1;LEN(A8)-FIND(" ";A1;1))

Cheers,
Flemming
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying data from different column 2
Removing a matching code from another cell 5
Vlookup not working because of duplicate matches 8
Macro or Function 7
Concatenate columns, variable number of rows 7
vlookup macro 1
CPSCount 2
how to check first 5 characters of a cell & then sum 5

Top