Insert brackets in string

J

jaimy

How to insert brackets in certain numbers?

I have a list of numbers from 1000 to 20000 where some of the number
such as 1100(A), 1307(E), 1611(A), 1611(B), 1612(C), 1612(D), 10303(1
and etc.

So, in column A1 , I enter 1000. In column A2, if I enter 1100 the
automatically it will change to 1100(A).
That means need to create a compare list to compare with the numbers
entered or there is a more efficient way to do this?

Any help would be greatly appreciated. Thanks

jaim
 
M

Mike

1. If 1100(A) is in Cell A2, we see 1000 (not 1100) in Cell A1, don't we?
2. If 1611(A) is in Cell A2, what do we see in Cell A1?
3. Is 1611(B) in Cell A3?
4. Which Cell is 1307(E) in?
5. Is 10303(1) correct, not 10303(I)?

Please don't let me ask so much any longer.
 
J

jaimy

Mike,

Actually, the numbers are not in sequence. The numbers represent som
project numbers. The users are required to enter their relate
projects' numbers in Column A from row 8 to row 20. So, the numbers ar
in random.

1. No
2. The numbers are enter by users.
3. No
4. Depends on the user.
5. Yes, 10303(1) is correct, there are 10307(I) also.

Hope, you understand now.

Thanks,
Jaim
 
M

Mike

Still I do not understand at all whay you want to do
Wait good advices from someone else

-
Mike
 
R

Ron_D

Jaimy,

You mentioned that these numbers, from 1000 to 20000, are project numbers. Are the single alpha/numeric character in () task identifiers for the project? Also, is column A just numbers without the single alpha/numeric character in ()? Is column B for user input of project numbers only and what do these inputs represent?

What I am trying to pin down is the organization of the spreadsheet. With more clarification on this and a clearer statement of what you want to accomplish, then we might have some ideas as to best help you.

Ron_D
 
B

BrianB

If there is some sort of common denominator you could have a formula
to covert. If the bracket numbers are random then a lookup table.

Regards
BrianB
==================================================
 
Top