Custom Cell Format - Number ending with text string

Good morning

I am stuck on figuring out how to modify a custom cell format to make data entry easier.

My goal is to have the output look like this: 'A12B-C20D: SET 10: Text string here'

Inputs needed are:

1-3 digit number between A & B
1-3 digit number between C & D
1-2 digit number after SET
Text string of variable length

Where I am stuck. So far I can get "A12B-C20D: SET 10:" to show up properly when 122010 is input. The custom format I am using looks like this: "A"##"B-C"##"D: SET "##": "

When I try to incorporate the "@" symbol the first part of the formatting goes away and the output shows up as "122010 Text string here".

I have tried:
"A"###"B-C"###"D: SET "##":";;-;_@
"A"###"B-C"###"D: SET "##": ";;@
"A"###"B-C"###"D: SET "##":";_@
"A"###"B-C"###"D: SET "##": ";;;@

Any help would be greatly appreciated! Thank you

BeautyBlues

I think that you are going to run into difficulties due to the varying digits between A&B and C&D (and you cannot use blanks, as it will make the entered value into text)

As for the "Text string here" - I do not believe that you can have variable text after digits (but maybe someone will prove me wrong!)

So that this is not entirely negative, I attach a workbook that shows one way of speeding up data entry.

Regards
Alastair

aydeegee:

Thank you for taking the time to respond. I appreciate the attached workbook as it looks like it could indeed help save some time. I will have to try that method!

Thanks again,
BeautyBlues

If you're able to put your numbers into individual cells to be referenced then you could use the & operator (or concatenate) to combine them with your text with a formula like this:

Formula:

Please Login or Register  to view this content.

BeautyBlues

Glad to have been of assistance. Could you now mark the thread as Solved ? This can be done by amending the header of your first post.

Regards
Alastair