I'm attempting to create a 3 digit number from a 4 digit number by removing the number in the second position.Please Login or Register to view this content.
1025 becomes 125
2056 -> 256
The formula above isn't doing it.
I'm attempting to create a 3 digit number from a 4 digit number by removing the number in the second position.Please Login or Register to view this content.
1025 becomes 125
2056 -> 256
The formula above isn't doing it.
Here is an alternate solution
=(LEFT(A1,1) & RIGHT(A1,2))*1
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
That will do it.
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks