jamesdor45
New Member
- Joined
- Feb 25, 2013
- Messages
- 21
Hi Guys!
A couple of days I posted a message and you manage to solve my problem! I have another question, which I hope you can help a newbie like me.
I need to create a sequence of letters + numbers that will according to this layout:
Take the first letter from each word showing in cell A1 + take the first letter from each word showing in cell B1. Then I need the system to generate a random number between 1-1000 that will show at the end. So it should show like this:
A1 – fat cat eating
B1 – dog is drinking
I then need to add a random numbers (between 1-1000) to the end. So what I will get in cell C1 is this:
C1 - fcedid876
Can you guys please help me with the formula? I tired playing and searching it all over but without any luck.
Thanks again,
Jerry
A couple of days I posted a message and you manage to solve my problem! I have another question, which I hope you can help a newbie like me.
I need to create a sequence of letters + numbers that will according to this layout:
Take the first letter from each word showing in cell A1 + take the first letter from each word showing in cell B1. Then I need the system to generate a random number between 1-1000 that will show at the end. So it should show like this:
A1 – fat cat eating
B1 – dog is drinking
I then need to add a random numbers (between 1-1000) to the end. So what I will get in cell C1 is this:
C1 - fcedid876
Can you guys please help me with the formula? I tired playing and searching it all over but without any luck.
Thanks again,
Jerry