Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to input additional text to multiple of existing cells that has text
I have a list of items for inventory and would like to add the text
"CAB - " to the beginning existing cells already created. For example: ALREADY CREATED: car truck scooter Changed to: CAB - car CAB - truck CAB - scooter This is for inventory naming. I'm sure there is an easy way and not have to manually do it. Thanks! |
#2
|
|||
|
|||
One way -
With original data starting in A1, enter this in B1: =IF(A1<"","CAB - "&A1,"") And copy down as needed. If you wish to delete the Text formula, and leave the data behind, select the Column B cells, and right click in the selection. Choose "Copy". Right click again, and choose "Paste Special". Click on "Values", then <OK, then <Esc. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== wrote in message ups.com... I have a list of items for inventory and would like to add the text "CAB - " to the beginning existing cells already created. For example: ALREADY CREATED: car truck scooter Changed to: CAB - car CAB - truck CAB - scooter This is for inventory naming. I'm sure there is an easy way and not have to manually do it. Thanks! |
#3
|
|||
|
|||
Maybe use a helper column of formulas:
=if(a1="","","CAB - " & A1) Then copy it down the column. If you want, you can edit|copy, edit|paste special|values and delete the first column. wrote: I have a list of items for inventory and would like to add the text "CAB - " to the beginning existing cells already created. For example: ALREADY CREATED: car truck scooter Changed to: CAB - car CAB - truck CAB - scooter This is for inventory naming. I'm sure there is an easy way and not have to manually do it. Thanks! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
input text at front of field that contains data | Excel Discussion (Misc queries) | |||
multiple text files URGENT | Excel Discussion (Misc queries) | |||
importing multiple text files URGENT!!! HELP | Excel Worksheet Functions | |||
importing multiple text files??? | Excel Discussion (Misc queries) |