LinkBack URL
About LinkBacks
Hi,
How do i bring only the number back on the below examples
$A$14
$A$103
$A$1032
$Ab$14
$Ac$103
$Acf$1032
so i would like it to say
14
103
1032
14
103
1032
Ive tried a right find formula but it doesnt work on all the cells
Hi,
How do i bring only the number back on the below examples
$A$14
$A$103
$A$1032
$Ab$14
$Ac$103
$Acf$1032
so i would like it to say
14
103
1032
14
103
1032
Ive tried a right find formula but it doesnt work on all the cells
This works
=RIGHT(A1,LEN(A1)-FIND(CHAR(255),SUBSTITUTE(A1,"$",CHAR(255),2)))
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Hi,
One way
Formula:
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
=MID(A1,FIND("$",SUBSTITUTE(A1,"$"," ",1))+1,256)
If you have data in Cell A1 try the above and copy towards down
Otherwise Change the Reference A1 according to your need
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
wow what a coincident
Post 2 at 06:39PM, Post 3 at 06:39PM and Post 4 at 06:39PM
If all data follows the same pattern as in the example, this simple formula works:
=MID(A1;FIND(1;A1;1);4)
A1 is your target cell, and if your data has values with more than 4 numbers (1032555 for example), then put a 7 or any other number that represents the lenght instead of the 4.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks