Add a string to a cell
 

I have a column with lots of rows having different numbers in it. I need
a add a string to each of the cell before the number.

For example:

Col A

1234
2345
3456
4567

String to be added = 'AB'

Result:

Col A
AB1234
AB2345
AB3456
AB4567

Any help please.... TIA.


--
ramsdesk
------------------------------------------------------------------------
ramsdesk's Profile: http://www.excelforum.com/member.php...o&userid=15705
View this thread: http://www.excelforum.com/showthread...hreadid=273074

Hi
using a helper cell in column B:
="AB"&A1



--
Regards
Frank Kabel
Frankfurt, Germany

"ramsdesk" schrieb im
Newsbeitrag ...

I have a column with lots of rows having different numbers in it. I
need
a add a string to each of the cell before the number.

For example:

Col A

1234
2345
3456
4567

String to be added = 'AB'

Result:

Col A
AB1234
AB2345
AB3456
AB4567

Any help please.... TIA.


--
ramsdesk
---------------------------------------------------------------------
---
ramsdesk's Profile:
http://www.excelforum.com/member.php...o&userid=15705
View this thread:
http://www.excelforum.com/showthread...hreadid=273074

You could try a "Custom" format of:
"AB"General,
Which display and print what you're asking.

This will leave the numbers as real numbers, just in case you might need
future calculations.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"ramsdesk" wrote in message
...

I have a column with lots of rows having different numbers in it. I need
a add a string to each of the cell before the number.

For example:

Col A

1234
2345
3456
4567

String to be added = 'AB'

Result:

Col A
AB1234
AB2345
AB3456
AB4567

Any help please.... TIA.


--
ramsdesk
------------------------------------------------------------------------
ramsdesk's Profile:
http://www.excelforum.com/member.php...o&userid=15705
View this thread: http://www.excelforum.com/showthread...hreadid=273074