jack

I am creating a userform that will allow a user to enter a playing card value into a textbox. But if the user enters "Jack" or "j" or "jack" or "11" (the numeric value of a jack), the text in the box will automatically change to a "J". So to be clear, any input that will indicate a jack, will...

Looking to output column "D" Render. Thank you A B C D 1 DR LOCUM MOD Render 2 smith jack Q6 jack 3 smith (blank) Q6 error 4 smith smith Q6 error 5 smith smith "<>Q6" smith 6 smith (blank)"<>Q6" smith 7 tom tom "<>Q6" tom 8...

Hello Column A has values X001 - X999 in cells X1:X999 Column B has text in the same cell range. How do I prefix all the cells in the range in Column B with 001-999 (i.e. ignoring the X) and a single space. e.g. Before: B1 = John Smith B2 = Jack Jones After: B1 = 001 John Smith B2 = 002...

hello guys , i have problem with Vlookup i have a sheet "board" like this B A yes Jack yes Ali no Sara yes Alex no Martin yes Tim and in another sheet i have a list for only Yes then i want list all the names with Yes in the "board" sheet in next sheet want like A...

This seems like it would be easy, but for the life of me I can't figure it out. I have three column ranges on a worksheet and i was trying to copy them to a different worksheet. BC-BX CA-CV DR-EM EO-FJ I think the column lengths are all equal. Is this even possible using Excel? Or do I need...