| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract hyperlink string from excel cell | Links and Linking in Excel | |||
| remove blanks from a string of chars within a cell? | Excel Discussion (Misc queries) | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| How to get a cell reference of by searchig a text string? | Excel Discussion (Misc queries) | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Hybrid Mode
