Another completely different approach would be to split column A into three columns using the '*' as the delimiter symbol, then join them all together again with
TEXT(A1/2.54,"0.00")&" * "&TEXT(B1/2.54,"0.00")&" * "&TEXT(C1/2.54,"0.00")
Another completely different approach would be to split column A into three columns using the '*' as the delimiter symbol, then join them all together again with
TEXT(A1/2.54,"0.00")&" * "&TEXT(B1/2.54,"0.00")&" * "&TEXT(C1/2.54,"0.00")
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks