Please use the following formula in C1 considering you have the numbers in A1 & B1
=CONCATENATE(TEXT(A1,"##,###.00")," AND ",TEXT(B1,"##%"))
Please use the following formula in C1 considering you have the numbers in A1 & B1
=CONCATENATE(TEXT(A1,"##,###.00")," AND ",TEXT(B1,"##%"))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks