I have a large column of numbers in the format of 111111-11. All the numbers
are random, but they are always six numbers, dash, then two more numbers.
Occasionally the first number will be the letter 't'. Anyway, I need to add
an * to the beginning and the end to this column. The reason is to convert
these numbers to a bar code with a bar code font, there has to be an * before
and after the text that is being converted to bar code. The idea is simple,
just adding an *, but in practice, I'm having a hard time.

Thanks

Hi,

What about this with your number in a1

="*"&A1&"*"

Mike

"Jeff" wrote:

I have a large column of numbers in the format of 111111-11. All the numbers
are random, but they are always six numbers, dash, then two more numbers.
Occasionally the first number will be the letter 't'. Anyway, I need to add
an * to the beginning and the end to this column. The reason is to convert
these numbers to a bar code with a bar code font, there has to be an * before
and after the text that is being converted to bar code. The idea is simple,
just adding an *, but in practice, I'm having a hard time.

Thanks

="*"&A1&"*"

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Jeff" wrote in message
...
I have a large column of numbers in the format of 111111-11. All the
numbers
are random, but they are always six numbers, dash, then two more numbers.
Occasionally the first number will be the letter 't'. Anyway, I need to
add
an * to the beginning and the end to this column. The reason is to
convert
these numbers to a bar code with a bar code font, there has to be an *
before
and after the text that is being converted to bar code. The idea is
simple,
just adding an *, but in practice, I'm having a hard time.

Thanks

Is the result you are looking for *111111-11* ?

If so, try this in the cell next to your number...

="*"&<<cell of number&"*"

Copy the cell, select a new cell, then paste special, select values to
remove the formula and replace your result.

"Jeff" wrote:

I have a large column of numbers in the format of 111111-11. All the numbers
are random, but they are always six numbers, dash, then two more numbers.
Occasionally the first number will be the letter 't'. Anyway, I need to add
an * to the beginning and the end to this column. The reason is to convert
these numbers to a bar code with a bar code font, there has to be an * before
and after the text that is being converted to bar code. The idea is simple,
just adding an *, but in practice, I'm having a hard time.

Thanks

One way:

In an adjacent column (say, "B"), enter

B1: ="*" & A1 & "*"

Copy down.

You can then select column B, copy it, then select column A and choose
Edit/Paste Special/Values.


In article ,
Jeff wrote:

I have a large column of numbers in the format of 111111-11. All the numbers
are random, but they are always six numbers, dash, then two more numbers.
Occasionally the first number will be the letter 't'. Anyway, I need to add
an * to the beginning and the end to this column. The reason is to convert
these numbers to a bar code with a bar code font, there has to be an * before
and after the text that is being converted to bar code. The idea is simple,
just adding an *, but in practice, I'm having a hard time.

Thanks