How do I replace astricks * with 0 in a column?

  • Thread starter Mitchell_Collen via AccessMonster.com
  • Start date
M

Mitchell_Collen via AccessMonster.com

I am not sure to use the replace fuction on this. Please help me.

I have three columns 'lblcode', 'prodcode', 'packcode'

They contain this data:
023443 2343 34
343234 2343 231
934233 2366 *3
834233 3434 *77

I want to create one columns named NDC with all the columns concatenated then
on the last column labeled 'packcode', it contains * with the number. I want
to replace the * with a 0

Do you know how to do this?

Thanks, Misty
 
M

Marshall Barton

Mitchell_Collen via AccessMonster.com said:
I am not sure to use the replace fuction on this. Please help me.

I have three columns 'lblcode', 'prodcode', 'packcode'

They contain this data:
023443 2343 34
343234 2343 231
934233 2366 *3
834233 3434 *77

I want to create one columns named NDC with all the columns concatenated then
on the last column labeled 'packcode', it contains * with the number. I want
to replace the * with a 0
Click to expand...


CombinedColumn: Replace(lblcode & ', ' & prodcode & ', ' &
packcode, "*", "0")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Replace cell values in multiple columns 3
how do I fill table column with same text string 1
How do I use "column" function to get the column number of the firstcell matching criteria? 2
How do I replace the #DIV/0! with blanks in the cells? 4
How do I find & replace pieces of a formula? 5
How do I replace decimals starting with "." to "0." in excel? 2
How do I replace non-constants in word? 6
how do I use macro to find and replace unicode characters 6

Top