View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
richprince richprince is offline
external usenet poster
 
Posts: 1
Default How to add a leading space to an existing text field?

I have 2 columns of data that I want to concatenate, however, I need a space
to separate the second column for readability. Example: column 1 (100)
column 2 (n. baker st.) - result: 100 n. baker st.

Excel 2007