View Single Post
  #2   Report Post  
RagDyer
 
Posts: n/a
Default

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!