Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find and copy part of a cell
Hallo,
I want to copy the last 10 spaces, always numbers/always 10, in cell A1 into cell B1. Can anyone help with a function that does this job? This is how cell A1 looks like: ABCDE AB 123 4 5 67 ABC A 123 4 5 67 Thanks, Srwe |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find and copy part of a cell
Do you want the spaces as well as the numbers? Then use
=RIGHT(A1,10) If you want the last 10 non-space characters, use =RIGHT(SUBSTITUTE(A1," ",""),10) "Srwe" wrote: Hallo, I want to copy the last 10 spaces, always numbers/always 10, in cell A1 into cell B1. Can anyone help with a function that does this job? This is how cell A1 looks like: ABCDE AB 123 4 5 67 ABC A 123 4 5 67 Thanks, Srwe |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find and copy part of a cell
Thanks!
Srwe "Duke Carey" wrote: Do you want the spaces as well as the numbers? Then use =RIGHT(A1,10) If you want the last 10 non-space characters, use =RIGHT(SUBSTITUTE(A1," ",""),10) "Srwe" wrote: Hallo, I want to copy the last 10 spaces, always numbers/always 10, in cell A1 into cell B1. Can anyone help with a function that does this job? This is how cell A1 looks like: ABCDE AB 123 4 5 67 ABC A 123 4 5 67 Thanks, Srwe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In excel I wish to copy the value from a cell. | Excel Worksheet Functions | |||
Copy the last cell in an Excel column to another cell | Excel Discussion (Misc queries) | |||
Find text in cell, copy row to new sheet | Excel Discussion (Misc queries) | |||
Copy Rows found using Find All feature | Excel Discussion (Misc queries) | |||
Copy one cell to entire column | Excel Discussion (Misc queries) |