PDA

View Full Version : Replace Space with a Line Break


psmosser
04-27-2012, 04:27 PM
Is there a way to use the replace function to create a line break where there is a space in a field.

i.e. [Color Name]= Autumn Blend

I would like it to return:

Autumn
Blend

Basically I have one field that will need to be 2 lines and I want to control the break based on the space in the field.