HELP ME PLEASEEE- how to format data in a column
 

I have like 5000 different data and I need to add letter ab in front of them.
Could anyone tell me how to do this.

for example 123 is what it says but I need ab123 and each row is different
number.

HELP ME PLEASEEE- how to format data in a column
 

Hi

Use a blank column with the formula:
="ab"&A2
where A2 contains your number.
Once you have filled this down the column, select them all and Ctrl+C
(Copy). Then select Edit/Paste Special/Values to fix the values in place.

Hope this helps.
Andy.

"Riza" wrote in message
...
I have like 5000 different data and I need to add letter ab in front of
them.
Could anyone tell me how to do this.

for example 123 is what it says but I need ab123 and each row is different
number.

HELP ME PLEASEEE- how to format data in a column
 

One way is to insert a column and use the following formula:

=concatenate("ab",A1)

[assuming Column A contains your original number]


"Riza" wrote:

I have like 5000 different data and I need to add letter ab in front of them.
Could anyone tell me how to do this.

for example 123 is what it says but I need ab123 and each row is different
number.

HELP ME PLEASEEE- how to format data in a column
 

Try this:

Use or insert a blank column somewhere then type:

="AB"&A1
copy down as far as needed, then copy the column and paste over the original
column (Paste Special - Values) then delete the helper column.

Note: it's always a good idea to save your data before trying anything new.

HTH
JG



"Riza" wrote:

I have like 5000 different data and I need to add letter ab in front of them.
Could anyone tell me how to do this.

for example 123 is what it says but I need ab123 and each row is different
number.

HELP ME PLEASEEE- how to format data in a column
 

If cell A1 contains 123, in cell B1 type ="ab"&A1. Copy down the entire
column. Then select column B, do a Copy and then Paste Special, Value.

"Riza" wrote:

I have like 5000 different data and I need to add letter ab in front of them.
Could anyone tell me how to do this.

for example 123 is what it says but I need ab123 and each row is different
number.

HELP ME PLEASEEE- how to format data in a column
 

Assuming all the numbers are in Col A, and are on consecutive rows, in Col B
write =€�ab€�&A1. Then highlite your whole Col B range, copy, paste special
values. Move it to Col A and youre done.

"Riza" wrote:

I have like 5000 different data and I need to add letter ab in front of them.
Could anyone tell me how to do this.

for example 123 is what it says but I need ab123 and each row is different
number.

HELP ME PLEASEEE- how to format data in a column
 

If you want a space then ="ab"&" "&A2

HTH
Regards,
Howard

"Riza" wrote in message
...
I have like 5000 different data and I need to add letter ab in front of
them.
Could anyone tell me how to do this.

for example 123 is what it says but I need ab123 and each row is different
number.

HELP ME PLEASEEE- how to format data in a column
 

Say A2 is the start of the column of data


Put this routine in a Module in VB Editor (Tools Macro Vb Editor )
Toolbar insert Module

Module1 shows in the projects window

copy and paste this macro into it



Close the vBeditor then
On the sheet toolbar Run macro


Sub AddABToData()
Dim strcell, strAB as string
strAB="AB"
range("A2") .select
set a=selection
'aSSUMES THERE IS MORE THAN ONE FILLED CELL
range(a,a.end(xldown)).select
for each cell in selection
if cell.value<"" then
strCell=strAB & cell.value
cell.value=strCell
end if
next

end sub

- -mark


"Riza" wrote:

I have like 5000 different data and I need to add letter ab in front of them.
Could anyone tell me how to do this.

for example 123 is what it says but I need ab123 and each row is different
number.

HELP ME PLEASEEE- how to format data in a column
 

Wow, Riza, This is the first time I saw a lot of responses from the community
with almost the same solutions. I envy you.

"exceluserforeman" wrote:

Say A2 is the start of the column of data


Put this routine in a Module in VB Editor (Tools Macro Vb Editor )
Toolbar insert Module

Module1 shows in the projects window

copy and paste this macro into it



Close the vBeditor then
On the sheet toolbar Run macro


Sub AddABToData()
Dim strcell, strAB as string
strAB="AB"
range("A2") .select
set a=selection
'aSSUMES THERE IS MORE THAN ONE FILLED CELL
range(a,a.end(xldown)).select
for each cell in selection
if cell.value<"" then
strCell=strAB & cell.value
cell.value=strCell
end if
next

end sub

- -mark


"Riza" wrote:

I have like 5000 different data and I need to add letter ab in front of them.
Could anyone tell me how to do this.

for example 123 is what it says but I need ab123 and each row is different
number.