inserting a dash into cells

T

tjackson

I am importing data from an old DOS system. I am trying to add a formula so
that numbers that import at "12345 678" can be reformatted to "12345-678".
I can import the two sets of numbers as one or two columns which ever will
let me accomplish the task.
Help please!
Thanks,
TJ
 
A

akphidelt

If you could import as 2 columns you can easily concatenate the numbers.

So in your example if those numbers were in A1 and B1 you would put the
formula in C1

=A1&"-"&B1
 

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

modifying a string 6
Adding a dash 3
how to return non empty cells over several columns 4
Sorting to Include Blank Rows 2
Importing text into number field- Error 4
Formula function(s) to do this? Or is it a formula at all? 4
Problem importing from access 1
How can I total on columns in a view? 9

Top